Article / Updated 10-03-2022
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+!