Exceljet

Quick, clean, and to the point

Apply number format

Windows shortcut

CtrlShift!

Mac shortcut

⌃⇧!

Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

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.

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Just like to say, your tutorial “INDEX and MATCH with multiple criteria” completely rocks. A colleague tried to teach me this a while ago and I couldn’t get it; a few years more experienced now, I needed this function today and nailed it on the first go after reading your article. -Shelley

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Shortcuts Video Course

Excel Charts video training course

Video training for Excel Tables