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
|