formating date problem

[Leslie]

I created an xls sheet with a column of dates with a chosen format of
12/12/2012. At somepoint in updated the sheet, the format of the date
columns has changed to numeric numbers in the thousands. I have been told
that the number is how many days since 1/1/1900. I have tried changing the
format to all the various date formats and it doesn't change. When
highlighting the field, my original input of format xx/xx/xxxx is still in
the display above, but defaults back to the xxxxx format in the field. Any
idea how to fix?

 

[ShaneDevenshire]

Hi,

Try this Tools, Options, View tab, and if Formulas is checked, uncheck it.