Formatting the Date

This Excel tip shows you how to format the date (day, month, year format) in an Excel spreadsheet using a keyboard shortcut.

Formatting the Date using a Keyboard Shortcut

1. Add the desired date to a cell in an Excel spreadsheet.
   
   
2. Click on the cell to make it the active cell.
   
   
3. Press and hold down the Ctrl and Shift keys on the keyboard.
   
   
4. Press and release the number sign key ( # ) on the keyboard without releasing the Ctrl and Shift keys.
   
   
5. The date in the active cell will be formatted in the day, month, year format.
   
   

Other Keyboard Shortcuts

• Adding the Current Date
• Adding the Current Time
• ALT - TAB Fast Switching in Windows

• excel tips
• excel keyboard shortcuts