presume c1=a1-b1

type in c1

="+"&a1-b1
remember it will be string.
================
"anoop" wrote in
message ...

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


--
anoop
------------------------------------------------------------------------
anoop's Profile:
http://www.excelforum.com/member.php...fo&userid=3066
View this thread: http://www.excelforum.com/showthread...hreadid=484757