hot to get + sign on positive nos
 

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

hot to get + sign on positive nos
 

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

hot to get + sign on positive nos
 

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

Hope this helps
Rowan

anoop wrote:
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