Negative Percentage in Parenthesis instead of with "-" sign
Format/ Custom:
0.0%;(0.0%)
--
David Biddulph
"silversun62280" wrote in message
...
How do you format a negative percentage to look like (5.2%) instead
of -5.2%
without formatting it as text. We need to be able to use it in a formula
and
when you format a number as text you cannot use it in a formula. Thanks!
|