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

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.
 
D

Debra Dalgleish

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.
 

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

VBA - exporting serial letters to single documents 0
Excel suddenly converts dates to serial numbers 1
Date and Number cell formats 4
Empty cells showing that they are default formated to "Date" 1
Excel pivot table, numbers are reverting to dates format 0
changing a minus serial number into a date within Excel 2003 3
Conditional Formatting from a group 6
date corruption? 00/01/1900 2

Top