number format

[Newbie]

I want to be able to format a number so that
if it is 0 it shows "-"
If it is positive is shows 2 decimal places like 10,500.30
If it is negative it shows in brackets like (10,500.30)

How can I do this

Thanks

A

 

[Bob Phillips]

Custom format of

#,###,##0.00;(#,###,##0.00);"-"

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Newbie]

thanks

Custom format of

#,###,##0.00;(#,###,##0.00);"-"

--

HTH

RP
(remove nothere from the email address if mailing direct)