Negative Percentage in Parenthesis instead of with "-" sign
Hi,
Right click on the cell you want to format, choos format cells, choos the
number tab, choos custom, enter in the Type text box: 0.00%;(0.00%)
hope this will work for you
--
Farhad Hodjat
"silversun62280" wrote:
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!
|