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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext