Problems with dates in Excel 2007
 

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?

Problems with dates in Excel 2007
 

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.

" wrote:

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

Problems with dates in Excel 2007
 

On Mar 4, 7:36*am, Dave Peterson wrote:
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.

" wrote:

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


Use Ctrl + Shift + #

to convert the 5 digit number to date format.

Problems with dates in Excel 2007
 

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.

muddan madhu wrote:

<<snipped
Use Ctrl + Shift + #

to convert the 5 digit number to date format.

--

Dave Peterson