Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
plus and minus sign in cells
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 "1" in cell D8, but I want it to show "+1" and Cell B11 = 4 Cell C11 = 5 =SUM(B8-C8) gives me a "-1" in cell D8, which is correct, however I want this to appear in red Grateful for any assistance. Thank you. -- ivoryhunter ------------------------------------------------------------------------ ivoryhunter's Profile: http://www.excelforum.com/member.php...o&userid=33327 View this thread: http://www.excelforum.com/showthread...hreadid=531492 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
plus and minus sign in cells
Something like
+#,##0;[Red]-#,##0;0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ivoryhunter" wrote in message ... 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 "1" in cell D8, but I want it to show "+1" and Cell B11 = 4 Cell C11 = 5 =SUM(B8-C8) gives me a "-1" in cell D8, which is correct, however I want this to appear in red Grateful for any assistance. Thank you. -- ivoryhunter ------------------------------------------------------------------------ ivoryhunter's Profile: http://www.excelforum.com/member.php...o&userid=33327 View this thread: http://www.excelforum.com/showthread...hreadid=531492 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
plus and minus sign in cells
Hi ivoryhunter (not very PC)
In Custom format: +#,##0;[Red]-#,##0 Regards Steve |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
plus and minus sign in cells
Thanks Bob and Steve. Bob - this is spot on - thank you. -- ivoryhunter ------------------------------------------------------------------------ ivoryhunter's Profile: http://www.excelforum.com/member.php...o&userid=33327 View this thread: http://www.excelforum.com/showthread...hreadid=531492 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|