View Single Post
  #2  
Old June 2nd, 2010, 04:24 AM posted to microsoft.public.excel.worksheet.functions
Jim Cone[_2_]
external usenet poster
 
Posts: 434
Default Keyboard shortcut for current date and time

CTRL+; then SPACE then CTRL+SHIFT+;
-or-
=Now()
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware



"Raj"
wrote in message
Hi,
Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current time.
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