Getting a positive percentage to have a + sign
 

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.

Getting a positive percentage to have a + sign
 

You can use a custom format variation of:

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

(positive;negative;zero;text)



Nelson B. wrote:

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

Getting a positive percentage to have a + sign
 

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


"Nelson B." wrote:

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.

Getting a positive percentage to have a + sign
 

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

"Dave Peterson" wrote:

You can use a custom format variation of:

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

(positive;negative;zero;text)



Nelson B. wrote:

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

Getting a positive percentage to have a + sign
 

Got it to work. Thanks for everybody's help

"Dave Peterson" wrote:

You can use a custom format variation of:

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

(positive;negative;zero;text)



Nelson B. wrote:

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