I meant format the cell as General after you hit the shortcutkey. Not before.

Does that work?

By the way, ctrl-shift-backquote (ctrl-tilde) is the shortcut key to change the
format to General.

"Daniel L. Lieberman" wrote:

Dave,
That is the whole point the ctrl+; does not appear as anything other than a
formatted date regardless of the cell formatting. To be more specific it
does not enter the date serial number even if the cell is formatted as
general.
Daniel

"Dave Peterson" wrote in message
...
I'm not sure why you can't process it as a date, but just change the
format to
general (or Number) after you apply the keystrokes.

"Daniel L. Lieberman" wrote:

The ctrl+; shortcut inserts the date as formatted in regional settings
rather than the "day number" date. I want the "day number" date so I can
process it.

Any suggestions?
TIA

Daniel L. Lieberman

--

Dave Peterson

--

Dave Peterson