plus and minus sign in cells

[ivoryhunter]

Hi,
I think this is an easy one but beyond me! How can I format the cel
to show the result of a sum as a plus or minus (or positive an
negative)? It shows minus values by default but I cannot get it t
show a plus sign. I have tried the Format Cells/custom part with n
joy. example:

Cell B8 = 3
Cell C8 = 2

=SUM(B8-C8) gives me a "1" in cell D8, but I want it to show "+1"

and

Cell B11 = 4
Cell C11 = 5

=SUM(B8-C8) gives me a "-1" in cell D8, which is correct, however
want this to appear in red


Grateful for any assistance.

Thank you

 

[Bob Phillips]

Something like

+#,##0;[Red]-#,##0;0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ivoryhunter" <[email protected]>
wrote in message
news:[email protected]...

 

[Scoops]

Hi ivoryhunter (not very PC)

In Custom format:

+#,##0;[Red]-#,##0

Regards

Steve

 

[ivoryhunter]

Thanks Bob and Steve.

Bob - this is spot on - thank you