Negative figures to appear in brackets
 

In excel, how can I get negative figures to appear in brackets
ie (7,500)

Negative figures to appear in brackets
 

Use a format of

#,##0;(#,##0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"madbat" wrote in message
...
In excel, how can I get negative figures to appear in brackets
ie (7,500)

Negative figures to appear in brackets
 

mad

If negative brackets are not available in the NumberNegative Numbers dialog.

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

StartSettingsControl PanelRegional and Language SettingsRegional
OptionsCustomizeCurrencyNegative 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 OKApply your way out.


Gord Dibben Excel MVP

On Wed, 19 Apr 2006 07:18:02 -0700, madbat
wrote:

In excel, how can I get negative figures to appear in brackets
ie (7,500)

Gord Dibben MS Excel MVP