Originally Posted by Ron Rosenfeld[_2_]

On Thu, 11 Oct 2012 22:29:11 +0000, chrisfordflorida wrote:

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% 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.