Add "+" plus symbol for a positive percentage

  • Thread starter chrisfordflorida
  • Start date
C

chrisfordflorida

Also want to keep a "-" for a negative percentage and...
want a 0% to remain 0%.

Right now I am using a custom cell format of

+#0#%;-#0#%

This works fine if it is a positive or negative 5% (i.e. +5% or -5%)
but if it is a 0% it shows +0%. For a 0% I want it to not show a '+' o
a '-'. Thank you
 
R

Ron Rosenfeld

Also want to keep a "-" for a negative percentage and...
want a 0% to remain 0%.

Right now I am using a custom cell format of

+#0#%;-#0#%

This works fine if it is a positive or negative 5% (i.e. +5% or -5%),
but if it is a 0% it shows +0%. For a 0% I want it to not show a '+' or
a '-'. Thank you.

The third slot is for values equal to zero:

+0%;-0%;0%
 
C

chrisfordflorida

'Ron Rosenfeld[_2_ said:
;1606107']On Fri, 5 Oct 2012 18:45:49 +0000, chrisfordflorid
Also want to keep a "-" for a negative percentage and...
want a 0% to remain 0%.

Right now I am using a custom cell format of

+#0#%;-#0#%

This works fine if it is a positive or negative 5% (i.e. +5% or -5%),
but if it is a 0% it shows +0%. For a 0% I want it to not show a '+ or
a '-'. Thank you.-

The third slot is for values equal to zero:

+0%;-0%;0%

It works. (+#0#%;-#0#%;#0#%) However, I just realized if I input -5% i
will show as -05%. I tried taking the '0' out +##%;-##%;##% and tha
solved the -5% however anywhere it is 0% it shows a blank. An
solution? Thank you
 
R

Ron Rosenfeld

It works. (+#0#%;-#0#%;#0#%) However, I just realized if I input -5% it
will show as -05%. I tried taking the '0' out +##%;-##%;##% and that
solved the -5% however anywhere it is 0% it shows a blank. Any
solution? Thank you.

The problem you describe does not occur if you use the custom format I recommended: +0%;-0%;0%

Also, I don't understand what you are trying to do with a #0#% type of format anyway. But the reason that ##% (or even #%) will show a blank if you have a zero value is because the # token, by design, does not display insignificant zero's.
 
C

chrisfordflorida

'Ron Rosenfeld[_2_ said:
;1606299']On Thu, 11 Oct 2012 22:29:11 +0000, chrisfordflorid
It works. (+#0#%;-#0#%;#0#%) However, I just realized if I input -5 it
will show as -05%. I tried taking the '0' out +##%;-##%;##% and that
solved the -5% however anywhere it is 0% it shows a blank. Any
solution? Thank you.-

The problem you describe does not occur if you use the custom format
recommended: +0%;-0%;0%

Also, I don't understand what you are trying to do with a #0#% type o
format anyway. But the reason that ##% (or even #%) will show a blan
if you have a zero value is because the # token, by design, does no
display insignificant zero's.

Thank you. You asked why I did the #0#% -- I blame it on my ow
ignorance. You're recommendation worked perfect
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top