Exceljet

Quick, clean, and to the point

Shortcuts for number formats

In this video, we'll look at shortcuts that Excel provides for applying number formatting.

First, just to recap, number formats control how a number is displayed, but they have no effect on the number's value. You can find a list of available number formats on the home tab of the ribbon.

Or you can use Control + 1 (command + 1 on a Mac) to see a list of number formats there.

Seven of these number formats have dedicated shortcuts, and they all begin with Control + Shift.

To apply the Currency number format, use Control + Shift + $

To apply the Percentage format, use Control + Shift + %

To apply the Scientific number format, use Control + Shift + ^

This is the same character that's used for exponents in Excel.

To apply the date number format, use Control + Shift + #

To apply the Time number format, use Control + Shift + @

And to apply the Number format, which applies decimals and commas, use Control + Shift + !

Finally, to revert a number back to the General format, use Control + Shift + ~

There are no dedicated keyboard shortcuts for increasing or decreasing decimal places in numbers. However, in Windows, you can use these ribbon shortcuts:

To increase decimal places, use Alt + H 0 
To decrease decimal places by one place, use Alt + H 9

You can also use Format Cells to set the number of decimal places exactly.
 

Course 
Excel Shortcuts

Related shortcuts

CtrlShift~
~
CtrlShift$
$
CtrlShift!
!
CtrlShift#
#
CtrlShift@
@
CtrlShift%
%
CtrlShift^
^
Author 
Dave Bruns