Exceljet

Quick, clean, and to the point

Apply number format

Windows shortcut

CtrlShift!

Mac shortcut

⌃⇧!

This shortcut will apply a Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

Excel offers many types of number formatting.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.

Shortcuts for number formats

In this lesson, we cover shortcuts you can use to apply key Excel number formats: General, Number, Currency, Date, Time, and Percentage.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Topics

Key functions

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

I love your website! I use it all the time. In fact, I used it over the past few weeks to help me make a great workbook. keep up the great work, and thanks for all the help your site has given me. -Steve

Apply number format

Related videos

Download 200+ Excel Shortcuts

Excel video training