Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 150
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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,549
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shortcut for current Time in hh:mm:ss Radhakant Panigrahi Excel Discussion (Misc queries) 2 May 13th 10 10:49 AM
keyboard shortcut for dates and Time rexmann Excel Discussion (Misc queries) 4 September 8th 09 02:09 PM
Excel 2007 Date Keyboard Shortcut problem Daniel L. Lieberman Excel Discussion (Misc queries) 9 May 17th 07 02:22 AM
Save as Current Date / Time Jacob_F_Roecker Excel Discussion (Misc queries) 1 October 25th 05 09:37 AM
Can I automatically enter the current date or current time into a Ben New Users to Excel 7 October 19th 05 03:38 PM


All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"