Office 2016 at Work For Dummies
Book image
Explore Book Buy On Amazon

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 [email protected]
Number format, two decimal places, thousands separator, minus sign for negative values Ctrl+Shift+!

About This Article

This article is from the book:

About the book author:

Faithe Wempen, M.A., has written more than 140 books on computer hardware and software, including Microsoft Office 2016 for Seniors for Dummies and The PowerPoint Bible. A Microsoft Office Master Instructor, she has educated more than a quarter of a million corporate students with her online courses, and hundreds more as an adjunct instructor at Purdue University.

This article can be found in the category: