Apply the Date format with the day, month, and year
-
CTRL+SHIFT+@
-
CTRL+SHIFT+!
-
CTRL+SHIFT+$
-
CTRL+SHIFT+#
D
Correct answer
Explanation
In Excel, CTRL+SHIFT+# applies the Date format showing day, month, and year (e.g., dd-mm-yyyy or similar depending on regional settings). This is the standard shortcut for date formatting. The other options are for different formats: CTRL+SHIFT+@ is time, CTRL+SHIFT+$ is currency, CTRL+SHIFT+! is number format with two decimals.