Negative numbers in brackets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot find an option for showing negative numbers in brackets when I go to
Format, cell, number. The only choices I find are either to show with minus
sign or in red. Any suggestions would be welcome.
 
Excel picks this up from a windows setting:

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.
 
Keith

If negative brackets are not available in the Number>Negative Numbers dialog.

This is a function of your Regional Settings in Windows OS.

Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow
and select the ($1.1)

Note: this is under the "Currency" tab in Regional Options. Changing under
the "Numbers" tab only does not do the trick.

Apply and OK>Apply your way out.


Gord Dibben Excel MVP

I cannot find an option for showing negative numbers in brackets when I go to
Format, cell, number. The only choices I find are either to show with minus
sign or in red. Any suggestions would be welcome.
Click to expand...

Gord Dibben MS Excel MVP
 
And just to clarify one point - it's parentheses, not brackets.

( ) are parentheses; [ ] are brackets; { } are braces
 
Back
Top