show negative figures in brackets

D

davesexcel

right click one the cell and select format cells,
select number tab, and the number catagory,
select the format you require
 
G

Guest

thanks for the help but my version of excel doesn't offer brackets as an
option in the number category, however I went to "Custom" and found the
brackets there.

thanks again and regards.
 
G

Gord Dibben

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

How do I display negative figures in brackets rather than the minus sign
Click to expand...

Gord Dibben MS Excel MVP
 

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

Similar Threads

Lining up decimal points with negatives in brackets 2
Accounting format now no longer display negative figures in ( )'s 2
Displaying negatives with (brackets) 3
Option to put brackets around negative numbers not available in 20 3
Negative figures in brackets 13
How do I align the figures when using brackets as a negative numbe 2
Formatting negative numbers in Excel 12
Negative Numbers in Brackets 2

Top