date display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't know what happened, everytine I type in the day ex. 1/2/2007 and hit
return, it changed into 39114, if I double click, it will changed to read
01/02/2007, but when I leave the cell, it changed back to 39114. I did try
to go to the format menu>cell>number>date>style and click OK dozens of times,
it still won't work.

Please help anyone.
 
Maybe...

Tools|Options|View|Uncheck Formulas
I don't know what happened, everytine I type in the day ex. 1/2/2007 and hit
return, it changed into 39114, if I double click, it will changed to read
01/02/2007, but when I leave the cell, it changed back to 39114. I did try
to go to the format menu>cell>number>date>style and click OK dozens of times,
it still won't work.

Please help anyone.
Click to expand...
 

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

date display as numbers 2
Default date format in excel 2
Date conversions 4
Date / Time Filter 2
SUMIF using dates in cells 5
Excel Date Display? 8
macro help 1
Lookup Maximum between Range of Dates 2

Back
Top