Negative figures to appear in brackets

  • Thread starter Thread starter Guest
  • Start date Start date
Use a format of

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
mad

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

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

Gord Dibben MS Excel MVP
 
Back
Top