Shortcut Keys

This is a list of all the shortcut keys related to dates and times.

Ctrl + ;Enters the current date/todays date into the active cell and applies the format "dd/mm/yyyy".
Ctrl + Shift + ; (:)Enters the current time into the active cell and applies the format "hh:mm".
Ctrl + #Applies the Date format "dd-mmm-yy" to the selection.
Ctrl + Shift + # (~)Applies the General number format to the selection. This can be used to display the serial number for a date.
Ctrl + ;
Enters the current date/todays date into the active cell and applies the format "dd/mm/yyyy".
Ctrl + Shift + ; (:)
Enters the current time into the active cell and applies the format "hh:mm".
Ctrl + #
Applies the Date format "dd-mmm-yy" to the selection.
Ctrl + Shift + # (~)
Applies the General number format to the selection. This can be used to display the serial number for a date.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext