Negative numbers in brackets

K

Keith

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.
 
G

Gary''s Student

Try something like:
Format > Cells... > Number Custom
General;(General);General;@
 
D

Dave Peterson

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.
 
G

Gord Dibben

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.

Gord Dibben MS Excel MVP
 
P

Paul D. Simon

And just to clarify one point - it's parentheses, not brackets.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top