View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
silversun62280 silversun62280 is offline
external usenet poster
 
Posts: 1
Default Negative Percentage in Parenthesis instead of with "-" sign

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!