Office For Seniors For Dummies
Book image
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 is an adjunct instructor at Indiana University Purdue University at Indianapolis (IUPUI). She is the author of over 150 books on computer hardware and software, and an online technology courseware developer whose courses have educated over a quarter of a million people.

This article can be found in the category: