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.
More Shortcuts
- Align Center (Excel Shortcut)
- Check Mark (Excel Shortcut)
- Currency Format (Excel Shortcut)
- Percentage Format (Excel Shortcut)
- Strikethrough (Excel Shortcut)
- Subscript (Excel Shortcut)
- Superscript (Excel Shortcut)
- Apply Time Format (Excel Shortcut)
⇠ Back to Excel Shortcut Keys (PDF Cheat Sheet)