hot to get + sign on positive nos

[anoop]

Dear all

Need quick help.

It is possible to get minus sign for negative nos.

But HOW CAN I GET PLUS '+' SIGN FOR POSITIVE CALCULATION.
E.G. SUBTRACT VALUE OF COL B FROM COL A and result should be +2


COL A COL B COL C
50 48 +2

if any body know how to do please reply soon.
Regards
Anoop

 

[R.VENKATARAMAN]

presume c1=a1-b1

type in c1

="+"&a1-b1
remember it will be string.
================

 

[Rowan Drummond]

Add custom formatting. Select the cell or cells you want to show the +
sign in. From the menus Format>Cells>Number. Select Custom and then in
the Type field enter:
+#,##0;-#,##0

Hope this helps
Rowan