Thread: date display
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pamwp pamwp is offline
external usenet poster
 
Posts: 4
Default date display

Thanks so much.

"Dave Peterson" wrote:

Maybe...

Tools|Options|View|Uncheck Formulas

pamwp wrote:

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 menucellnumberdatestyle and click OK dozens of times,
it still won't work.

Please help anyone.


--

Dave Peterson