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

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

I get the same result a) starting Vista Business in safe mode, and b)
starting excel in the safe mode (/s switch.)

Daniel

"Daniel L. Lieberman" wrote in message
...
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

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

Dave,

It doesn't matter you format the cell before or after using the shortcut
key. What do you get when you use the key.

I just tried using the key into general, long date and short date cells and
then changing them and it made no difference.

Daniel


"Dave Peterson" wrote in message
...
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

You don't have a macro that steals the ctrl-; keystroke and does some special
stuff, do you?

I'd try opening excel in safe mode:

Close excel
windows start button|Run
excel /safe

and test it out



"Daniel L. Lieberman" wrote:

Dave,

It doesn't matter you format the cell before or after using the shortcut
key. What do you get when you use the key.

I just tried using the key into general, long date and short date cells and
then changing them and it made no difference.

Daniel

"Dave Peterson" wrote in message
...
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

--

Dave Peterson

even if the cell is formatted as general.


If the cell is 'number' formatted it stays a number.


--
Jim
"Daniel L. Lieberman" wrote in message
...
| 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
|