Wauvel
Excel like a finance pro.
← The library

Formatting shortcut

Apply number format with two decimals and thousands separators

Ctrl + Shift + ! on Windows, Ctrl + Shift + ! on Mac.

CommonDifficulty 1109 · Proficient
Practice · 2 questions →

When to use it

Applies the number format with two decimals, thousands separators, and negatives with a minus sign.

The shape of it

Windows
Ctrl + Shift + !
Mac
Ctrl + Shift + !

Worked examples

  • Number format

    Select raw numbers, Ctrl + Shift + ! → 12,345.68 style

    Readable numbers in one keystroke.

  • Counts

    On a whole column of counts, Ctrl + Shift + ! → Separators added, .00 shown

    Then Decrease Decimal twice.

  • Reset

    Ctrl + Shift + ~ → Back to General

    Reset.

Worth knowing

  • The ! is on the 1 key: Ctrl + Shift + 1.
  • Decrease Decimal on the ribbon trims the .00.
  • Comma Style on the ribbon is the accounting version without a symbol.

Where it goes wrong

  • Always two decimals initially.
  • Does not right-align text numbers; convert them.

Related

Ctrl + 1Ctrl + BCtrl + ICtrl + UCtrl + Shift + $Ctrl + Shift + %

Learn the moves here — or let Wauvel run them on your numbers.

$99/mo, everything included. Free for 14 days, no card.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.