Format cell value with date formatting – Microsoft Excel shortcut
If you are working with multiple dates, this shortcut can help save time by changing the format within all selected cells to a date-based format. When used shortcut will add convert your numbers to a date beginning with day, then abbreviated month, then year.
`
1
2
3
4
5
6
7
8
9
0
-
=
[
]
Lock
;
'
,
.
/
`
1
2
3
4
5
6
7
8
9
0
-
=
[
]
\
;
'
,
.
/
Ctrl Shift #
Table of contents
Worksheets and Workbooks View Row and Column Selection Ribbon Control Pivot Tables Operating within a Cell Navigating and Selecting Cells Help and Menus Group Selection General Excel General Cell Control Formulas and Functions Formatting Text and Numbers Dialog Boxes Borders Advanced Selection Adding Content to CellsGet more Reference tips and tricks
Subscribe to our email updates and get Reference tips direct to your inbox.