Set Date Format with Day - Month and Year
Master this Excel shortcut with our comprehensive guide
Formatting Shortcuts
Ctrl + Shift + #
⌘ + Shift + #
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + #
Instructions
1. Select date cells
2. Press Ctrl + Shift + # to apply day-month-year format
2. Press Ctrl + Shift + # to apply day-month-year format
Keyboard Shortcut
⌘ + Shift + #
Instructions
1. Highlight date cells
2. Press Command + Shift + # to format as day-month-year
2. Press Command + Shift + # to format as day-month-year
💡 Pro Tip: Standardizes dates for easier sorting and presentation.