View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel 2007 Date Keyboard Shortcut problem

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