Custom cell format for percentage

[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

 

[John C]

Format-->Cells-->Custom format
0.00%;(-0.00%)
This will put a parentheses around a negative percent as well as put the
negative sign.

 

[Klee]

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!

 

[John C]

Thanks for the feedback, and don't forget to check the box