Negative figures to appear in brackets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

madbat - 19 Apr 2006 15:18 GMT

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

Reply to this Message

Bob Phillips - 19 Apr 2006 15:53 GMT

Use a format of

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

Reply to this Message

Gord Dibben - 19 Apr 2006 20:14 GMT

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)

Gord Dibben MS Excel MVP

Reply to this Message