Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format changes unexpectedly
Excel 2003, SP2
I have a spreadsheet with cells formatted as "General". They repeatedly revert back to "text". I also have conditional formats which still work, however I can no longer see them when I open the conditional formatting window. Are these a formatting limitation or is there a fix? Thx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format changes unexpectedly
Format the cell with the formula as General (or what you want)
The with that cell still selected, hit F2, then hit enter. Saved from a previous post. Excel likes to help. Try this on a test worksheet. Select A1 and hit ctrl-; (to put the date in the cell) now select B1 and type: =a1 Notice that excel changed the format of B1 to match the format in A1. Now format D1 as Text. put ASDF in D1 put =D1 in E1 You see ASDF. With E1 selected, hit the F2 key and then enter (to pretend that you're changing the formula). Excel has "helped" you by changing that cell's format to text. I don't know of any way of changing this behavior. I just select the cell, and reformat it to General (or whatever I wanted). I hit F2 and then enter (to reenter that formula). Sometimes this feature is nice, sometimes it ain't. HappyDaddy wrote: Excel 2003, SP2 I have a spreadsheet with cells formatted as "General". They repeatedly revert back to "text". I also have conditional formats which still work, however I can no longer see them when I open the conditional formatting window. Are these a formatting limitation or is there a fix? Thx -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My cell format changes unexpectedly after copy/paste | Excel Discussion (Misc queries) | |||
Can you reproduce Excel unexpectedly closing? | Excel Discussion (Misc queries) | |||
Excel Closes Unexpectedly | Excel Discussion (Misc queries) | |||
Excel quits unexpectedly | Excel Worksheet Functions | |||
data changes unexpectedly | New Users to Excel |