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
- First, select the cells or the column that have dates as values.
- After that, simply press the “Ctrl + Shift + #” keys together and your date values will get converted to a uniform date format.