Excel Keyboard Shortcuts for Number Formats

Bottom line: Learn 8 quick keyboard shortcuts to apply number formatting in Excel for Windows & Mac.

Skill level: Beginner

Video Tutorial

Watch on YouTube and give it a thumbs up.
YouTube Subscribe Logo Excel Campus

Download the File

You can download the Excel file that contains the printable shortcut guide below.

Number Formatting Shortcuts Ctrl Shift.xlsx (44.9 KB)

Number Format Shortcuts Guide

If you spend a lot of time formatting numbers in Excel (who doesn't?) then you will love these shortcuts. The Ctrl+Shift+Number Key shortcuts allow us to quickly apply some of the most popular number formatting options including: currency, percent, number, date, and time.

Here is a quick guide that explains what each shortcut does.

Excel Number Formatting Shortcuts Ctrl Shift Number Keys

The diagram shows the Ctrl & Shift keys on the left side. However, you can also use the Ctrl & Shift keys on the right side of the keyboard. This might make it easier to use two hands to press the combination.

To apply the formatting shortcut:

  1. Press & hold Ctrl
  2. Press & hold Shift
  3. Then press one of the number keys at the top of the keyboard.

The format will be applied to the selected cell(s).

The shortcuts work on both the Windows and Mac versions of Excel.

You can use the

General Number Format Shortcut

Ctrl+Shift+~ is the shortcut to apply the General format.

General Number Format Keyboard Shortcut Excel Ctrl Shift Tilde

General is the default number format for all cells on a blank sheet. If the cell contains a number then it displays raw numbers without any comma separators, currency/percentage symbols, etc.

Number Format Shortcut

Ctrl+Shift+1 [!] is the shortcut to apply the standard Number format.

,##0.00
Number Format Keyboard Shortcut Excel Ctrl Shift 1

The Number format has a separator for thousands, millions, etc. and two decimal places. The characters used for the separator will depend on your locale settings in Windows.

Time Format Shortcut

Ctrl+Shift+2 [@] is the shortcut to apply the Time format.

h:mm AM/PM
Time Format Keyboard Shortcut Excel Ctrl Shift 2

The Time format displays hours:minutes and AM/PM at the end. Checkout my article on the date system for Excel to learn more about date & time data types.

Date Format Shortcut

Ctrl+Shift+3 [#] is the shortcut to apply the Date format.

dd-mmm-yy
Date Format Keyboard Shortcut Excel Ctrl Shift 3

This shortcut uses the day-abbreviate month-year format. I don't know of any way to change the shortcut to apply a different date format. It's unfortunate because this is NOT a date format I use very often.

Please leave a comment below if you do know how to change the default date format for Ctrl+Shift+3.

Note: Assigning this shortcut to a macro would be a potential workaround. However, you would lose the undo history when the macro runs.

Checkout my Formatting Shortcuts Add-in for ways around this, plus the ability to create keyboard shortcuts for custom number formats, font & fill colors, and cell styles.

Currency Format Shortcut

Ctrl+Shift+4 [$] is the shortcut to apply the Currency format.

$#,##0.00_);[Red]($#,##0.00)
Currency Format Keyboard Shortcut Excel Ctrl Shift 4

The Currency format display a currency symbol, thousands separator, and red text for negative numbers.

What about the Accounting Format Shortcut?

This was a question that came up from Kim and Gina on the YouTube video. Unfortunately there is no dedicated Ctrl+Shift shortcut, however, there are some alternatives.

One way is: Alt, H, A, N, Enter. That basically presses the Accounting format button on the Home tab of the ribbon.

Another option is to right-click that button and Add to Quick Access Toolbar. Then move it to the first position in the toolbar. The shortcut to press the first button is Alt+1. The second button is Alt+2, and so on. Here is an article that explains more about the QAT shortcuts.

Percent Format Shortcut

Ctrl+Shift+5 [%] is the shortcut to apply the Percent format.

0%
Percent Format Keyboard Shortcut Excel Ctrl Shift 5

The Percent format display the percent symbol and no decimal places. Please leave a comment below with tips on how you quickly increase/decrease the number of decimal places.

Scientific Format Shortcut

Ctrl+Shift+6 [^] is the shortcut to apply the Scientific format.

0.00E+00
Scientific Format Keyboard Shortcut Excel Ctrl Shift 6

The Scientific format is typically used for very large numbers. It displays a decimal number, followed by an E (for exponent), and then the power that the decimal number is raised to.

Apply Black Border Shortcut

Ctrl+Shift+7 [&] is the shortcut to apply a black border to the selected cell(s).

Apply Black Border Keyboard Shortcut Excel Ctrl Shift 7

If a range of cells is selected then the black border will be applied around the entire selection.

Clear All Borders Shortcut

Ctrl+Shift+_ [underscore] is the shortcut to remove ALL borders from the selected cells. If the selection contains borders on the interior cells then those will also be removed.

Clear All Borders from Selected Cells Keyboard Shortcut Excel Ctrl Shift Underscore

Therefore, this shortcut is NOT the exact opposite of Ctrl+Shift+7 when a range of cells is selected.

Additional Resources

If you have numbers stored as text, checkout these articles:

What Are Your Favorite Ways to Apply Number Formats?

The Ctrl+Shift+Number shortcuts are awesome for quick formatting tasks. However, there are A LOT of different ways to apply number formats in Excel.

What are some of your favorite shortcuts and techniques for applying number formats? Please share your answer by leaving a comment below. Thank you! 🙂

13 comments

Your email address will not be published. Required fields are marked *

  • Hi John!
    I run payroll reconciliations daily and several of my wage codes begin with 3E. 3E10, 3E20, 3E50, 3E70 etc. When these codes are exported out of our pay system into excel they are automatically formatted as scientific. The only way I have been able to prevent this is by making them text which creates downstream errors with formulas. Is there any way around this auto change to scientific format?

  • Hello Jon!
    The only shortcut that seems to work with an AZERTY (french) keyboard is the % mark, with Ctrl+Shift+ù (%). On the figures rank of the keyboard, C+S+1 opens the cell format dialog box, C+S+2 formats in bold, C+S+3 formats in italics, C+S+4 underlines, C+S+5 strikeouts, C+S+ +(=) opens the cell insertion dialog box. C+S+< deletes the content, that's all I've seen. A bit disappointing, compared with what can be done with the qwerty keyboard.
    Best regards.
    Jacques

  • Hi Jon

    The keyboard that i am using in England works with the same characters wherever they are on the keyboard. . . i use CONTROL SHIFT 4 ($) and get the £ sign format.
    note:-
    My @ sign is not above the number 2 but still returns the time format.
    My # sign is not above the number 3 and does not require the SHIFT key but works great for the date.

    Best regards
    Kevin

  • <SHF – Copy cell above current cell (numeric values including formatting)
    Copy cell above current cell (numeric values not including formatting)

    why not mention this tip too
    Convert Text to Numbers – Excel Keyboard Shortcuts December 6, 2009 Jon Acampora
    Excel has a built-in feature to convert text to numbers, but it can be tricky to use when you are trying to select a long list of cells or multiple rows and columns. In the video below I describe how to use keyboard shortcuts to accomplish this very quickly.

    • oops, lost part of that previous reply

      ’ CTL SHF – Copy cell above current cell (numeric values including formatting)
      ` CTL – Copy cell above current cell (numeric values not including formatting)

      and
      1 CTL to launch for Formt dialog to get to all formatting

  • Hi Jon,

    Are there similar shortcuts for an AZERTY keyboard (Belgian period)?
    Not all of the previous shortcuts work on my keyboard.

    Kind regards,
    Jo

    • Hi Jo,
      Great question! Unfortunately I don’t know the equivalents for AZERTY keyboards and it’s tough to find resources on it. Please let us know if you figure out the equivalents, or which ones work for you. It would be great to have a resource for others in Europe.

      Thanks!

    • Hi Pierre,
      Sorry to hear that. I’m not sure about the equivalents for the AZERTY keyboard. I couldn’t find any info on this. Please let us know if you are able to find any of the shortcuts. Thanks!

  • Hi Jon,
    Thanks for an excellent compilation of formatting shortcuts
    I would also add here another useful shortcut which is relatively close to the others: CTRL + 1
    It opens “Format Cells…” form, where we can play with the formats too

Search
Generic filters
Exact matches only
Filter by Custom Post Type

JOIN US & LEARN EXCEL

Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
Plus weekly updates to help you learn Excel.

Download the eBook

About Me

Jon Acampora Profile

Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

MVP_Horizontal_BlueOnly