200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Format cell value with date formatting

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.

Ctrl Shift #

Control Shift #

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.