+/- prefix on sum result

[id107]

If I have 3 simple columns with column c being b-a. Is there a way I can prefix the result in column c with "+" before any positive numbers and "-" before any negative numbers?

 

[Richard Schollar]

Hi

Sure - go Format>Cells>Number tab, click the Custom category and use a custom format of:

+#,##0.00;-#,##0.00

You can amend the number of decimal places you want to suit.

 

[VoG]

Try a Custom format

+0.00;-0.00;0.00