number format
 

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

number format
 

Custom format of

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

--

HTH

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


"Newbie" wrote in message
...
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

number format
 

thanks
"Bob Phillips" wrote in message
...
Custom format of

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

--

HTH

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


"Newbie" wrote in message
...
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