dates switch to general format

[dbSPI]

I have an XLS workbook and the date formats switch to General format when I
close and reopen the file

 

[Francis]

If you have format your dates.
I suspect that you need to click "Yes" if prompt to save changes
Try again...if it doesn't work, not post back
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

 

[Dave Peterson]

When you select a cell that has a date that's displayed in general format, what
do you see in the formula bar?

If you see the real date, then you may be looking at formulas.

In xl2003 menus:
Tools|Options|View tab|and make sure Formulas is not checked.