Unable to format cells

In my Excel 2003 application, I select a range of cells and set a vertical 
border. This also works in Excel 2007 until I save it from the latter into 
the compatible format. If I then open it again with 2007, it's inoperative. I 
select the range, right-click, then click on format cells and nothing 
happens. If I open it again with 2003, it works. If I then save from 2003 and 
then open it with 2007, it will work. Any ideas?
0
Utf
2/13/2010 12:43:01 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
1150 Views

Similar Articles

[PageSpeed] 19

Reply:

Similar Artilces:

Combining Cells #2
I wish to combine two cells, want the cell to appear as Chicago Golf Club 04/15/04, where Chicago Golf Club is cell a1 and 04/14/04 is cell b1. When I use the formula a1&" "&b1 the date is shown as a number. Is there anyway it can be shown as a date? This cell will then be used to save the file, using a macro. Hi try =A1&" "&TEXT(B1,"MM/DD/YY") -- Regards Frank Kabel Frankfurt, Germany ABYPFCS wrote: > I wish to combine two cells, want the cell to appear as Chicago Golf > Club 04/15/04, where Chicago Golf Club is cell a1 and 04/14/04 ...

cell formatting zero padding on binary no's
I'm struggling through doing some binary math on excel. Ugh. You'd think Excel is written by programmers, so they would see the value of having some programmer-friendly bitwise math and binary, octal and hex formatting stuff in there, if for no other reason than they could use it themselves. Anyway, that's my rant, here's my question I have some numbers in cells that I convert to binary C5: 55 DEC2BIN(C5) gives me 1010101 I'd really like to display that as 0101 0101 .... ie with a leading zero and a space between the nibbles. It appears that ce...

The numbers entered change to symbols when leaving the cell
I am trying to enter 10,418 in a dollar amount, when I leave the cell it changes to this :########. How can I fix this? Make the column wider, or the font size smaller. George Gee "CH100688" <CH100688@discussions.microsoft.com> wrote in message news:303ADD36-C519-4A11-B38D-86E61DA66D53@microsoft.com... >I am trying to enter 10,418 in a dollar amount, when I leave the cell it > changes to this :########. How can I fix this? Thanks...that worked!! "George Gee" wrote: > Make the column wider, or the font size smaller. > > George Gee > >...

More about Format Object
This is an extension of my previous question about 'Forma Object:Properties:Move and Size'. If I paste a picture ( 'picture (enhanced metafile)' ) from anothe program into excel it free floats above the worksheet. If I 'forma object' and set it to 'move and size' with cells, should it not sor with another column? Move if I move the row or column it is on? I am little confused here about what this format option is really doing. From everything I read, it appears that it should. In my hands it doe not move with cells. It does resize to the cell it is over b...

Conditional formatting in text boxes
I have textboxes on a userform. The text boxes read (and write) to cells A1:A60 Adjacent to these cells I have a comments column which is filled in for particular rows Depending on whether the adjacent cell in column B has an entry, is there a way to make the textboxes change their font attributes? For example, become BOLD when there is a comment. Can anyone help? You should have posted your code..Within your loop add a line something like the below.. Dim intCount as Integer For intCount = 1 To 60 Me.Controls("Textbox" & intCount).Font.Bold = _ No...

Setup unable to install some components--on a Vista machine
I am running Vista Home Premium with SP1 installed. When I try to install Money Plus Deluxe, I get the dreaded "Setup is unable to install some components. Try reinstalling Money." I've read all of the threads I can find about this error message, but all seem to deal with XP, not Vista. I've tried everything I can find on the newsgroups, etc., to no avail. Has anyone running Vista had this problem and if so, pleas help!!!!!! In microsoft.public.money, kennyjones wrote: >I am running Vista Home Premium with SP1 installed. When I try to install >Money Plus D...

Copy Cell Value (text) to Header?
I want to grab the text in a cell (company's name) and automatically copy it to the header using a macro. Thanks for any help. Mike Mike, Try something like ActiveSheet.PageSetup.LeftHeader = ActiveSheet.Range("A1").Text -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com chip@cpearson.com "theFrog" <none@none.com> wrote in message news:3uyrb.8918$si2.4367128@news4.srv.hcvlny.cv.net... > I want to grab the text in a cell (company's name) and automatically copy it > to the header using a macro. ...

Cell Data Change to Trigger Macro
Is there a way to trigger a macro whenever data changes in a cell? The value in the cell will be varying numbers, so it can't be TRUE/FALSE etc. Thanks Mike, Yes. Put it in the sheet module, instead of a regular module. It should look like this: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A1")) Is Nothing Then MsgBox "You changed cell A1, you did." End If If Not Intersect(Target, Range("A1").EntireColumn) Is Nothing Then MsgBox "You changed something in column A. You sure did." End If End ...

cell reference from =max
What i am trying to do is find the maximum value from a list of ammounts, then from that maximum value (which i need in one cell as a value) i need to find who that max figure relates to from a list of names ie. Sheet2 A B 1 fred 1.00 2 gareth 2.00 3 laura 3.00 Sheet3 A B 1 =max('sheet2'!B1:B3) =3.00 this cell needs to display name ie laura god what a nightmare, also from this i need to do the same with =large('sheet...

Unable receive messages from hotmail to the Exchange 2003 server
Exchange 2003 (SP2) +IMF enabled on Win Server 2003. Symantec AV 9.0.x and symantec mail security server (SMS) 4.6.1 installed. Just got some users complaints these days that they are not able to receive emails from Hotmail.com to the Exchange 2003 server, but no problem for yahoo, gmail and other email servers. The hotmail user got the following message: --- Subject : Delivery Status Notification (Failure) This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed. user@company.com -- Had this problem last year when installed Sym...

Number Format #6
Can anyone help. The following code is part of a number generator, that fills a column with numbers in the format "0000" ie on 5 instances of AI, numbers 0700 - 0704 will be generated. However, when I try to add "+" or "-" to the end of the number, the numbers generated are 0700+, 701+, 702+, 703+, 704+. After the first instance I loose the leading "0". Any ideas on how I can maintain my number format, and also add "+" or "-" to the end of it. Thanks Alec Case "AI" .Offset(0, 4).Value = counter(4 * Z - 2, 0) &a...

How do I move some information in one cell to another cell?
I have a column of information on a worksheet. Each cell in this column holds a number that looks like this 0408015568GH. I need to take the "GH" and move it to another column on the same worksheet. How do I do this? Hi Deborah, Not sure if you want the original to remain. If you don't a macro might be better. Don't know if it is always the last two characters but the following will handle it that way. =LEFT(A1,LEN(A1)-2) =RIGHT(A1,2) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/e...

PA Invoice Format Project Summary Page 2
Hi: I am modifying PA Invoice Format Project Summary Page 2, in project accounting. I need to add Category IDs and their costs in the Billing Sections of the Project. At this time only summary information is printing, i.e Vendor Invocies and Other Charges. I want to show the cost categories aginst which these invoices and charges are. I added cost category table into the tables list, created one new section by using cost category Id, Added the Cost Category field in the new section. This section is underneeth of H3, where it should be. Now when I run the report, it does not run. It gi...

How to merge columns and rows into one cell besides using Merge and Center Icon? #2
J.E: Although David McRitchie's page seems to have everything about basic macros which you have said that this is the only solution to my question, I have tried the example of recording and running macros on my question but it doesnt seem to work; the rows and columns did not merge into one cell. heres how my question goes; I have text data value in D1; Super-Com Distribution Pte Ltd, and in D2; Sales and Stock Half-Yearly Report For 2002. I need to merge the rows and columns from A1 to J2 into one cell and centralise the data within. Could you just show me the way of doing it? I'm b...

Variable/Adaptive Numeric Format
in Access 2007 I some report fields that are to display quantities and amounts the range of these numbers could be large (100,000 or $345,999) or small (0.375 or $0.0625) is there a way to have the field formatted to adapt to the range of the value being displayed for example if the value has no significant decimals then display the value without decimal places (512.00 becomes 512) or if the value has many decimals limit the display to only 2 decimals (0.63712938 becomes 0.64) -- Jim How do you propose to explain to Access how to tell that a number "has no significa...

Drop Down List
Hi Everyone I have created some drop-down lists using Data / Validation / Allow Lists The lists work fine BUT the viewing size of data in the list is tweeny weeny and some people in the office will have trouble reading what's in the list! How can I: A) Change the text size B) Change the number of lines shown in the list? many thanks Try Debra's page at: http://www.contextures.com/xlDataVal08.html Scroll down around halfway for the topics: Data Validation Font Size and List Length Make the Dropdown List Appear Larger -- Max Singapore http://savefile.com/projects/236895 xdemech...

Cell formatting #17
Periodically, all my formulas show the formula rather than the result. I've tried changing the cell format but it doesn't revert. I have to close the file without saving and then reopen. What causes this and how can I revers it? Thanks Try Ctrl ~ http://www.rondebruin.nl/print.htm#Formulas -- Regards Ron de Bruin http://www.rondebruin.nl "Wizzer" <anonymous@discussions.microsoft.com> wrote in message news:674c01c52805$2576fe30$a501280a@phx.gbl... > Periodically, all my formulas show the formula rather than > the result. I've tried changing th...

Number self formatting
If I type in an integer value into a cell it gets divided by 1000. What do I do ? Alannes, Sounds like the fixed decimal places is set. Go into Tools>Options>Edit, and see if the Fixed Decimal check box is checked. If so, uncheck it. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Alanness" <anonymous@discussions.microsoft.com> wrote in message news:0c4501c3fb27$cf196470$a501280a@phx.gbl... > If I type in an integer value into a cell it gets divided > by 1000. What do I d...

Conditional Format four top four cells
Using this for conditional formating, however if I have a blank cell it still changes the cell format according to the rule. =A1>=LARGE($A$1:$A$5,4) Data 2 3 5 7 8 Would like the 3,5,7,8 to change cell color based on formula in coditional Format Thanks Rob Rob, Your 'blank' cell is not blank - it has a space or a null string ("") in it. Try =AND(A1<>"",A1<>" ",A1>=LARGE($A$1:$A$5,4)) HTH, Bernie MS Excel MVP "Rob" <Rob@discussions.microsoft.com> wrote in message news:F382DA31-1889-4C1C-8178-3923A9BDB953@micro...

How do I split cells in excel when making a table?
I am making a table. The first column is my primary column. I want the second column to contain multiple choices and I want he user to pick multiple choices, how do I do that should I split the cells, if so how? Debra Dalgleish has a web site where you can learn about creating drop down lists using "Data Validation". http://www.contextures.com/xlDataVal01.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! -----------------------------------------------------------...

keeping named cell references.
Spreadsheet File B references by name a cell value in Spreadsheet File A. When File A is opened, the references in B convert from the range name to the cell location (i.e from "Value" to B2) and stay that way even when File A is closed. How do I maintain range name references when the referenced file is opened? ...

How to select cells (located in a column) for formulas in a row automatically?
Hello How to use cells (located in a column) in formulas in a row automatically? I cannot copy the formula to other cells in the row because the coping moves the selection to another column, not to a another row in the same column. Use a $ (dollar sign) infront of the row or column you do not wat to change. "Dmitry Kopnichev" <kopn@bk.ruDelete> wrote in message news:OqbeN%23lzFHA.460@TK2MSFTNGP15.phx.gbl... > Hello > How to use cells (located in a column) in formulas in a row automatically? > I > cannot copy the formula to other cells in the row because the ...

Count the Colorindex of a cell with a conditional format
Is there any way (with or without code) to count the number of cells that have a condition that displays a specific colorindex tied to a conditional format? Thanks, Barb Reinhardt Barb, I answered no to this once and Bob Philips corrected me and pointed me towards his page below. You can count conditionally formatted cells but it ain't easy. http://www.xldynamic.com/source/xld.CFConditions.html -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the questio...

Finding unnamed cells in a range
How do I find unnamed cells within a range of cells? I have a range of over 3000 named cells and I want to find whcih ones are unnamed. Is this possible? Thanks Here is one way Sub testAntiUnion() Debug.Print AntiUnion(Range("$A1:$H100")).Address AntiUnion(Range("$A1:$H100")).Select End Sub '-----------------------------�------------------------------�------ Function AntiUnion(UsedRange As Range) As Range '-----------------------------�------------------------------�------ Dim saveSet Dim rng As Range Dim nme As Name For Each nme In ActiveWorkbook...

Formatting a date different from the date options available
I am using ACCESS 2007 and would like to format the date as ex: 2009-Nov-19 in a table. It would also be nice if this cell would automatically format the date to the above format even if the person entering the date typed in 7/9/1975. Could anyone help me do this, or can it even be done? Thanks, Janet B Janet B <Janet B@discussions.microsoft.com> wrote: >I am using ACCESS 2007 and would like to format the date as ex: 2009-Nov-19 >in a table. It would also be nice if this cell would automatically format >the date to the above format even if the person entering ...