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" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
>

[Newbie]

thanks
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Custom format of
>
> #,###,##0.00;(#,###,##0.00);"-"
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Newbie" <[email protected]> wrote in message
> news:%[email protected]...
>> 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
>>
>>
>
>