Apply Date Format (Excel Shortcut)

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.
  2. After that, simply press the “Ctrl + Shift + #” keys together and your date values will get converted to a uniform date format.