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 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.
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.

Download 200+ Excel Shortcuts

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

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas