dates switch to general format

  • Thread starter Thread starter dbSPI
  • Start date Start date
D

dbSPI

I have an XLS workbook and the date formats switch to General format when I
close and reopen the file
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to default file save format to .xlsx in Excel? 9
unintended format changes Excel 2007 3
Keep Losing My Cell Format 7
Remove date format? 3
Cell Format 1
Losing date format when saving .csv files 10
all General formats of the workbook changed to date format suddenl 1
How to change language on windows 1

Back
Top