The following is a list of shortcuts for formatting date-time in MS Excel:
- Ctrl + Shift + R - Format cells as date.
- Ctrl + Shift + D - Format cells as time.
- Ctrl + Shift + T - Format cells as time with am/pm.
- Ctrl + Shift + H - Format cells as 24 hour clock.
- Ctrl+Shift+ A – Apply the same formatting to all cells in the selection.
Share a personalized message with your friends.