Prev: Matching like items
Next: Converting number to text
From: Raj on 1 Jun 2010 23:08
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
From: Jim Cone on 1 Jun 2010 23:24
CTRL+; then SPACE then CTRL+SHIFT+;
-or-
=Now()
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware



"Raj" <rspai9(a)gmail.com>
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
 | 
Pages: 1
Prev: Matching like items
Next: Converting number to text