custom format

[Ali]

How can I create a custom format for a percentage to show
up like this (21%)? I am able to do it but get a negative
sign in front of the number.

 

[Ron Rosenfeld]

How can I create a custom format for a percentage to show
up like this (21%)? I am able to do it but get a negative
sign in front of the number.

(0%)

works for me. It gives a negative sign only if the % is negative.

If you want 21% if positive, and (21%) if negative, then:

0%;(0%)


--ron