In Excel 2016, use the following keyboard shortcuts instead of the Number drop-down list on the Home tab to apply number formatting to Excel worksheet cells.
| To apply this number format | Use this key combination |
|---|---|
| General | Ctrl+Shift+~ |
| Currency with two decimal places, negative numbers in parentheses | Ctrl+Shift+$ |
| Percentage, no decimal places | Ctrl+Shift+% |
| Scientific, two decimal places | Ctrl+Shift+^ |
| Date format with day, month, and year | Ctrl+Shift+# |
| Time format with hour and minute, AM or PM | Ctrl+Shift+@ |
| Number format, two decimal places, thousands separator, minus sign for negative values | Ctrl+Shift+! |
