Display Plus(+) or Minus(-) Signs with Percent Format

[isadoko]

I cannot find a posting relative to this though I think I've seen it in past so here goes "again" if already out there and pardon my not finding it if so.

I want to make my percent results appear as plus (+) or minus (-), for example, the rate of increase over the last period was plus 10 percent, ie, "+10%" instead of "10%". Excel already takes care to show a minus sign, eg, "-10%". I think it's done in Format Cells/Custom.

Thanks in advance for the help.

 

[Scott Huish]

Perhaps a custom format of:

+0%;-0%;0%

 

[mortgageman]

I cannot find a posting relative to this though I think I've seen it in past so here goes "again" if already out there and pardon my not finding it if so.

I want to make my percent results appear as plus (+) or minus (-), for example, the rate of increase over the last period was plus 10 percent, ie, "+10%" instead of "10%". Excel already takes care to show a minus sign, eg, "-10%". I think it's done in Format Cells/Custom.

Thanks in advance for the help.

The following worked for me: Go to Format Cells/Custom (just like you thought) and then choose 0.00%. Then EDIT IT to +0.00%

 

[mortgageman]

The following worked for me: Go to Format Cells/Custom (just like you thought) and then choose 0.00%. Then EDIT IT to +0.00%

Just saw hotpeppers. Use his. Mine does not work if the number is negative.

 

[isadoko]

Thank you both--I've applied the hotpepper solution successfully.

 

[tamtam1991]

Perhaps a custom format of:

+0%;-0%;0%

Would like to add my thanks, I used it for a different formula where I wanted to display +0;-0;0 according to the value. Worked like a charm.

 

[excelish]

Thank you Scott Huish, I used it too and it helped me in the right time