Ctrl+Shift+3: Applies the Date Format

The shortcut Ctrl+Shift+3 is to apply the date format with the day, month and year, please also see shortcut Ctrl+Shift+Number Sign (#).

Step 1: Select the data you want to change the date format;

Step 2: Press and hold the Ctrl and Shift keys, then press number "3" from the keyboard. The date changed from MM/DD/YYYY to DD-MMM-YY when pressing shortcut Ctrl+Shift+3.

Check More Excel Shortcuts

Leave a Reply