Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shortcut for current Time in hh:mm:ss | Excel Discussion (Misc queries) | |||
keyboard shortcut for dates and Time | Excel Discussion (Misc queries) | |||
Excel 2007 Date Keyboard Shortcut problem | Excel Discussion (Misc queries) | |||
Save as Current Date / Time | Excel Discussion (Misc queries) | |||
Can I automatically enter the current date or current time into a | New Users to Excel |