Many shortcuts are available that can save you time with simple tasks in Excel 2016, such as copying text from one place and pasting it somewhere else in your document. You can use these keyboard shortcuts instead of the Number drop-down list on the Home tab to apply number formatting to cells in Excel 2016.
| 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+! |