Excel 2016 Number Formatting Shortcuts

By Faithe Wempen

Part of Office 2016 At Work For Dummies Cheat Sheet

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+!