Custom cell format for percentage

  • Thread starter Thread starter Klee
  • Start date Start date
K

Klee

I'm trying to figure out how to do a custom cell format for percentages.
Currently the negative percentage numbers show up as -100%. I'm trying to
figure out if there is a way to make them display as (-100%) instead (with
brackets but not in red).

Does anyone know if this is possible?

Thanks very much
 
Format-->Cells-->Custom format
0.00%;(-0.00%)
This will put a parentheses around a negative percent as well as put the
negative sign.
 
Thanks so much, I thought I had tried that but it was making all of my
positive amounts negative so I must have done something wrong. It works great
now.

Thanks again!
 
Back
Top