Excel 2016 Number Formatting Shortcuts - dummies

Excel 2016 Number Formatting Shortcuts

By Faithe Wempen

Part of Office 2016 For Seniors For Dummies Cheat Sheet

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