Excel Shortcuts:
Keyboard shortcuts in Excel allow you to reduce the time spent doing routine task using mouse and thereby boosting productivity.
Below is a list of Excel shortcut keys to convert number into different Time and Date formats.
1) To Convert Number to Date format: Select the range of cells that contain numbers and press CTRL+SHIFT+3
2) To Convert Number to Time format: Select the range of cells that contain numbers and press CTRL+SHIFT+2
3) To Convert Number to Percentage format: Select the range of cells that contain numbers and press CTRL+SHIFT+5
4) To Convert Number to Currency format: Select the range of cells that contain numbers and press CTRL+SHIFT+4