Formats the selected cells as a date in the d-mmm-yy style, so Mar 15, 2024 shows as 15-Mar-24. Only the display changes. If a number turns into an odd date, that is because Excel counts dates as days since Jan 1, 1900.
More Format shortcuts
- Apply the Currency formatCtrl+Shift+4
- Open Format CellsCtrl+1
- Group rows or columnsAlt+Shift+Right
- Hide the selected columnsCtrl+0
- Hide the selected rowsCtrl+9
- Apply the Number formatCtrl+Shift+1
- Add an outline borderCtrl+Shift+7
- Apply the percent formatCtrl+Shift+5
- Apply the Scientific formatCtrl+Shift+6
- Apply strikethroughCtrl+5
- Apply the Time formatCtrl+Shift+2
- Ungroup rows or columnsAlt+Shift+Left
- Unhide rowsCtrl+Shift+9