software

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

Use a format of

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;madbatquot; gt; wrote in message
...
gt; In excel, how can I get negative figures to appear in brackets
gt; ie (7,500)
mad

If negative brackets are not available in the Numbergt;Negative Numbers dialog.

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

Startgt;Settingsgt;Control Panelgt;Regional and Language Settingsgt;Regional
Optionsgt;Customizegt;Currencygt;Negative Currency Format. Click on drop-down arrow
and select the ($1.1)

Note: this is under the quot;Currencyquot; tab in Regional Options. Changing under
the quot;Numbersquot; tab only does not do the trick.

Apply and OKgt;Apply your way out.Gord Dibben Excel MVP

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

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

Gord Dibben MS Excel MVP