Home

Excel 2019 Number Formatting Shortcuts

|
|  Updated:  
2018-10-09 18:13:04
Microsoft Power Platform For Dummies
Explore Book
Buy On Amazon
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+!

About This Article

This article is from the book: 

About the book author:

Faithe Wempen, M.A., is a Microsoft Office Master Instructor and the author of over 150 books on computer technology, including Outlook 2019 for Dummies and PowerPoint Bible. She is also a CompTIA A+ certified PC technician and an adjunct Computer Technology instructor at Purdue University. Her online courses in Office applications and digital literacy have educated over a quarter of a million students for corporate clients.