I am having the same problem. It is happening on all sheets, all workbooks.
I have even reformatted to numbers multiple times, saved, and when I reopen,
they are once again dates.

"Gord Dibben" wrote:

Does this happen with all worksheets on all workbooks?

New sheets? New Workbooks?

Sounds like all cells are formatted as Date.


Gord Dibben MS Excel MVP


On Wed, 27 Jan 2010 11:32:01 -0800, Chris K.
wrote:

Thanks that works, is there a way to turn it off in the settings or not?
Would be nice if there is because then I wouldn't have to do this all the
time.

"????? (????) ?????" wrote:

Try to select the whole(!) sheet and then hit: Ctrl+Shift+1
*** The 1 in the upper horizontal numeric keys ***
If this resolves the problem - you may continue formatting your sheet as
General or whatever...
Micky

.