Incorrect Date Formats

M

Mark

Hello,

When I enter a date like 03/24/06 I am getting a strange number "38976"
instead of the date. I have checked the format of the cell and it is
correct. It will appear correctly when I click on the cell. Using Office
XP (for now).

Thanks!
 
D

Dave Peterson

tools|options|view|uncheck formulas
Hello,

When I enter a date like 03/24/06 I am getting a strange number "38976"
instead of the date. I have checked the format of the cell and it is
correct. It will appear correctly when I click on the cell. Using Office
XP (for now).

Thanks!
Click to expand...
 
Top