date and time

  • Thread starter Thread starter annie
  • Start date Start date
A

annie

Does anybody know if there is a keyboard shortcut that inserts the current
date AND time, i.e., in General date format? I know that Ctrl-; inserts
date and Ctrl-: inserts time, but I'd like both in one key stroke.

Also, is there a function that inserts date and time?

Thanks!!!
 
Does anybody know if there is a keyboard shortcut that inserts the current
date AND time, i.e., in General date format? I know that Ctrl-; inserts
date and Ctrl-: inserts time, but I'd like both in one key stroke.
Click to expand...

Not that I know of, but you can push
ctrl-; space-bar ctrl-:

Peter
 
Not sure if this is what you're looking for in your second part, but the
Now() function returns both date and time.

You might be able to create an AutoKeys macro that assigns some key
combination to use the Now function to assign both.
 
To expand on Doug's reply, create an AutoKeys macro with a name like
Macro Name Keystrokes
^q ^; ^:
Save the macro as AutoKeys. Then when you press Ctrl+Q, the date and time
will be inserted.
 
Back
Top