Excel Keyboard Shortcut Date & Time

[wsnyder]

Hi all,

I see shortcut for Date and a shortcut for time.

Is there a keyboard shortcut to insert date & time in Excel?
I need: 11/3/2022 11:24:10 in one cell.

Thanks,
-w

 

[Fluff]

No there isn't, but you can use the date shortcut & then space & then the time shortcut.

 

[wsnyder]

No there isn't, but you can use the date shortcut & then space & then the time shortcut.

Thanks Fluff,

That'll have to work for now.

Thanks,
-w

 

[Fluff]

Your'e welcome & thanks for the feedback.

 

[My Aswer Is This]

We could write a Vba script to do this:
The script could be entered into your Personal Folder and could be used in any workbook
Just use a shortcut key to enter Date and Time into active cell.