show negative figures in brackets

[Guest]

How do I display negative figures in brackets rather than the minus sign

 

[davesexcel]

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

 

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

 

[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

Gord Dibben MS Excel MVP