Problems with dates in Excel 2007

  • Thread starter Thread starter adamtanderson
  • Start date Start date
A

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?
 
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.
 
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.
Click to expand...


Use Ctrl + Shift + #

to convert the 5 digit number to date format.
 
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.
 
Back
Top