View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
HJ
 
Posts: n/a
Default Percentage formatting

Never mind. I figured it out. I used the custom format of 0% and added the
following to the format: 0%;(0%)

"HJ" wrote:

Is there a way to format a cell that has a negative % to be (100%) vs. -100%?