Problems with dates in Excel 2007

[adamtanderson]

I am having problems displaying dates in Excel 2007. I have a sheet in
a workbook that is not displaying dates correctly. It shows the date
correctly in the formula bar, but in the cells on the worksheet are
displayed as 5 digit numbers. Anyone have any Idea what I may have
done?

 

[Dave Peterson]

You're looking at formulas.

You can toggle this setting by hitting:
ctrl-`
(control-backquote, backquote is the key to the left of the 1/! on my USA
keyboard)

Or you can use
Office Button|Excel Options
and search for view section and uncheck formulas.

 

[muddan madhu]

You're looking at formulas.

You can toggle this setting by hitting:  
ctrl-`
(control-backquote,  backquote is the key to the left of the 1/! on my USA
keyboard)

Or you can use
Office Button|Excel Options
and search for view section and uncheck formulas.

Use Ctrl + Shift + #

to convert the 5 digit number to date format.

 

[Dave Peterson]

That changes the format of the cell. But since the user is already seeing a
date in the formulabar, I don't think this will help.