Dates Not Formatting as Dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

awacs - 13 Sep 2005 18:43 GMT

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

Reply to this Message

Dave Peterson - 13 Sep 2005 19:55 GMT

Maybe you're just showing formulas:

Tools|Options|View tab|Uncheck Formulas.

> ... 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
[quoted text clipped - 4 lines]
>
> Thanks!

Signature

Dave Peterson

Reply to this Message

awacs - 13 Sep 2005 20:03 GMT

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!

Reply to this Message

Dave Peterson - 13 Sep 2005 20:07 GMT

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!

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

Signature

Dave Peterson

Reply to this Message

Ray A - 13 Sep 2005 22:35 GMT

Tools>Options>View tab>Window Options > formula should not be checked
HTH

> .... 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
[quoted text clipped - 4 lines]
>
> Thanks!

Reply to this Message