dates suddenly changed from x/xx/2004 format to number

  • Thread starter Thread starter scheinz
  • Start date Start date
S

scheinz

I set up my excel 2003 for dates to be written 4/25/2004
and instead all I get is serial numbers. I tried to
format the cell for the date as above but it only comes
out in serial numbers. When I set this spead sheet up it
worked fine. The suddenly this changed and the dates went
away. I cannot reverse this. any hints.
 
As answered by Jim Rech in excel.misc --

Maybe you hit Ctrl-~ by accident and changed to "formulas view"? Hit it
again or uncheck Tools, Options, View, Formulas.
 
Back
Top