This is a list of all the shortcut keys related to dates and times.
|Ctrl + ;||Enters the current 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.|
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext