Apply Date Format (Excel Shortcut)

puneet-gogia-excel-champs

- Written by Puneet

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

Manytimes when you extract the data that has dates as values in the cells from any tool, ERP, or Software, there could be a possibility of having that values in numeric or non uniformed date formats.

To make those values into a standard date format, you need to apply the date format using the quick keyboard shortcut, which will convert the values into a standard date format.

Keyboard Shortcut to Apply Date Format in the Excel

Ctrl + Shift + #

Steps to Apply Date Format Using Keyboard Shortcut

  1. First, select the cells or the column that have dates as values.
    select-the-date-values
  2. After that, simply press the “Ctrl + Shift + #” keys together and your date values will get converted to a uniform date format.
    uniform-date-format
Last Updated: May 23, 2024