Back to library
Microsoft Excel

Apply Currency Format with Two Decimals and Parentheses for Negatives

Applies the Currency number format with two decimal places and encloses negative numbers in parentheses.

Ctrl + Shift + $

When to use it

When you need to format selected cells as currency in Excel or other spreadsheet software.

Pro tip

Ensure the cell selection is active before pressing the keys. This shortcut works in many spreadsheet applications.

Esc F1 F2 F3 F4
F5 F6 F7 F8
F9 F10 F11 F12
PrtSc Scroll Pause
` ~ 1 ! 2 @ 3 # 4 $ 5 % 6 ^ 7 & 8 * 9 ( 0 ) - _ = +
Ins Home PgUp
Tab Q W E R T Y U I O P [ { ] } \ |
Del End PgDn
Caps A S D F G H J K L ; : ' " Enter
Shift Z X C V B N M , < . > / ? Shift
Ctrl Win Alt Space Fn Alt Ctrl

More from Microsoft Excel View all