Is there a way to have a positive number show a +?

[kufta4]

Is there a way to have a positive number show a + and a negative number show a -?

I know excel already shows the - for the negative. I would like a positive 7 to show as +7 and a negative one to show as -7.

Thanks.

[MarvinP]

Hi kufta4,

Does http://www.ozgrid.com/forum/showthread.php?t=60444 answer the question?

[NBVC]

Format as Custom:

+0;-0;0;@