Exceljet

Quick, clean, and to the point

Apply date format

Windows shortcut 
CtrlShift#
Mac shortcut 
#

This shortcut applies the Date format "dd-mmm-yy" to the selection. You can also use the shortcut Control + 1 to open the Format cells dialog box, which allows you to choose other date formats and to apply a custom date format. Once you have applied a date format, you can use Paste Special > Formats to apply the format to other cells.

Related videos

The videos below demonstrate this shortcut.
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.
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 look at how to use VLOOKUP to lookup values in an Excel Table.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.