Excel 2019 Number Formatting Shortcuts

By Faithe Wempen

Part of Office 2019 For Seniors For Dummies Cheat Sheet

Many shortcuts are available that can save you time with simple tasks in Excel 2019, 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 2019.

 

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