negative numbers as brackets an Excel option

C

cameron

When I want to format my numbers in Excel through Format\cell\number\number
the option of choosing negative numbers displayed in brackets "(#,###.##)" is
not available. How do I obtain that option?
 
S

Sheila D

You need to look at the option for Custom formatting which allows you to
specify how you want Positive, Negative etc figures displayed. You should be
able to find something close to the format you need and then change it as
required. HTH
 
G

Gord Dibben

Cameron

Don't know what you have tried but this is the standard fix 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
 
Top