Dates Not Formatting as Dates

A

awacs

.... 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!
 
A

awacs

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!
 
D

Dave Peterson

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!
 
Top