Thread: HOW DO YOU SET THE DEFAULT TIME FOR DATE IN EXCEL TO 8:00 AM?
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 HOW DO YOU SET THE DEFAULT TIME FOR DATE IN EXCEL TO 8:00 AM?
Ctrl-: puts the current time in the cell--there is no default.

David wrote:

I would prefer to have the default time be 8:00 am rather than 12:00 AM when
I use the ctrl : shortcut.
Anyone know how to do this?

--

Dave Peterson
Reply With QuoteReply With Quote