Exceljet

Quick, clean, and to the point

Apply date format

Windows shortcut 
CtrlShift#
Mac shortcut 
#

This shortcut will apply the Date format with the day, month, and year.

Excel offers many types of number formatting.

Related videos

The videos below demonstrate this shortcut.
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.
In this lesson, we cover shortcuts you can use to apply key Excel number formats: General, Number, Currency, Date, Time, and Percentage.
In this video, we'll look at how to use INDEX and MATCH with an Excel Table. Using INDEX and MATCH with an Excel Table is wonderfully straightforward.
In this video, we'll look at how to generate a sequence of dates with the SEQUENCE function.