Getting a positive percentage to have a + sign

[Nelson B.]

I often show the difference between relative percentages and would like to
have a positive number show up as +9%. Currently I only have -9% and 9%.
Any help would be appreciated.

 

[Dave Peterson]

You can use a custom format variation of:

+0.00%;-0.00%;0%;@

(positive;negative;zero;text)

 

[Brad]

Custom format
+0%,-0%
If you want the numbers rounded to a whole percentage

 

[Nelson B.]

Is this under the "custom" section of cell formatting?

 

[Nelson B.]

Got it to work. Thanks for everybody's help

You can use a custom format variation of:

+0.00%;-0.00%;0%;@

(positive;negative;zero;text)