View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Daniel L. Lieberman Daniel L. Lieberman is offline
external usenet poster
 
Posts: 11
Default Excel 2007 Date Keyboard Shortcut problem

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