By using shortcut.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

73 Shortcuts for Excel

Shortcut 52 - Ctrl+; - Date

Inputs the date into Excel in mm/dd/yyyy format or whatever your default date format is.

Dates in Excel are the number of days from Jan 1, 1900.

If you want to enter the date and time:
Ctrl+; Ctrl+: (Ctrl+Semicolon, space, Ctrl+Colon)