Short cut to apply date format with day, month and year
-
CTRL + SHIFT + A
-
CTRL + SHIFT + # (POUND)
-
CTRL + D
-
CTRL + SHIFT + D
Reveal answer
Fill a bubble to check yourself
B
Correct answer
Explanation
CTRL + SHIFT + # applies the default date format (dd-mmm-yy or similar) showing day, month, and year. The pound/number symbol key is used for date formatting. This is a quick way to apply standard date formatting to selected cells.
AI explanation
In Excel, Ctrl+Shift+# applies the built-in date format showing day, month, and year (e.g., dd-mmm-yy). Excel reserves a set of Ctrl+Shift+ shortcuts for quickly applying common number formats, and # is the one mapped to the date format.