date display
 

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.

date display
 

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

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