View Single Post
  #1  
Old June 2nd, 2010, 04:08 AM posted to microsoft.public.excel.worksheet.functions
Raj[_4_]
external usenet poster
 
Posts: 27
Default Keyboard shortcut for current date and time

Hi,

Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me

Ctrl+Shift+; inserts the current time with the date serial as 0 and
not the current date's date serial.

Presently I am adding the two (ie current date and time) to get the
current date and time. Is there a keyboard shortcut that does this?

Thanks in advance.

Regards,
Raj