Dates Not Formatting as Dates
 

.... I have a particular Excel sheet. Any date I enter shows up as an
ordinal number (in the cell and printing; in the formula bar it
displays correctly), notwithstanding that I format it as a date.
Anywhere on this sheet. A new sheet added to the workbook behaves as
expected. Obviously, I'm missing something (tried Format-Style and
AutoFormat), but what?

Thanks!

Maybe you're just showing formulas:

Tools|Options|View tab|Uncheck Formulas.

awacs wrote:

... I have a particular Excel sheet. Any date I enter shows up as an
ordinal number (in the cell and printing; in the formula bar it
displays correctly), notwithstanding that I format it as a date.
Anywhere on this sheet. A new sheet added to the workbook behaves as
expected. Obviously, I'm missing something (tried Format-Style and
AutoFormat), but what?

Thanks!

--

Dave Peterson

Yes! That hit the spot.

Now I'll scratch my head and wonder how that box got checked (sheet
came from Excel for Mac).

Thank you!

There's a shortcut key to toggle this setting.

ctrl-` (ctrl-backquote)

On my USA keyboard, it's to the left of the 1/! key.

Maybe too easy to hit!

awacs wrote:

Yes! That hit the spot.

Now I'll scratch my head and wonder how that box got checked (sheet
came from Excel for Mac).

Thank you!

--

Dave Peterson

ToolsOptionsView tabWindow Options formula should not be checked
HTH

"awacs" wrote:

.... I have a particular Excel sheet. Any date I enter shows up as an
ordinal number (in the cell and printing; in the formula bar it
displays correctly), notwithstanding that I format it as a date.
Anywhere on this sheet. A new sheet added to the workbook behaves as
expected. Obviously, I'm missing something (tried Format-Style and
AutoFormat), but what?

Thanks!