date and time

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!!!
 
P

Peter Doering

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
 
D

Douglas J. Steele

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.
 
D

Duane Hookom

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.
 
Top