software

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

Cell B8 = 3
Cell C8 = 2

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

and

Cell B11 = 4
Cell C11 = 5

=SUM(B8-C8) gives me a quot;-1quot; in cell D8, which is correct, however I
want this to appear in redGrateful for any assistance.

Thank you.--
ivoryhunter
------------------------------------------------------------------------
ivoryhunter's Profile: www.excelforum.com/member.php...oamp;userid=33327
View this thread: www.excelforum.com/showthread...hreadid=531492Something like

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;ivoryhunterquot; gt;
wrote in message
...
gt;
gt; Hi,
gt; I think this is an easy one but beyond me! How can I format the cell
gt; to show the result of a sum as a plus or minus (or positive and
gt; negative)? It shows minus values by default but I cannot get it to
gt; show a plus sign. I have tried the Format Cells/custom part with no
gt; joy. example:
gt;
gt; Cell B8 = 3
gt; Cell C8 = 2
gt;
gt; =SUM(B8-C8) gives me a quot;1quot; in cell D8, but I want it to show quot; 1quot;
gt;
gt; and
gt;
gt; Cell B11 = 4
gt; Cell C11 = 5
gt;
gt; =SUM(B8-C8) gives me a quot;-1quot; in cell D8, which is correct, however I
gt; want this to appear in red
gt;
gt;
gt; Grateful for any assistance.
gt;
gt; Thank you.
gt;
gt;
gt; --
gt; ivoryhunter
gt; ------------------------------------------------------------------------
gt; ivoryhunter's Profile:
www.excelforum.com/member.php...oamp;userid=33327
gt; View this thread: www.excelforum.com/showthread...hreadid=531492
gt;
Hi ivoryhunter (not very PC)

In Custom format:

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

Regards

Steve
Thanks Bob and Steve.

Bob - this is spot on - thank you.--
ivoryhunter
------------------------------------------------------------------------
ivoryhunter's Profile: www.excelforum.com/member.php...oamp;userid=33327
View this thread: www.excelforum.com/showthread...hreadid=531492