Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
showing plus sign
How do I get a "+" sign to show up when I do a formual =a1-b1. The minus
sign shows up, but I would like to see the plus sign for positive results. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
showing plus sign
I'm sure there's probably another way, but one way:
=IF(A1-B10,"+" & A1-B1,A1-B1) HTH, Paul "asg2307" wrote in message ... How do I get a "+" sign to show up when I do a formual =a1-b1. The minus sign shows up, but I would like to see the plus sign for positive results. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
showing plus sign
The "+" sign is not used within Excel - like in Lotus (if that is what you
mean).. All formulas should begin with the = character. In a blank cell entering 123 (assumes a positive (+) sign). It is used like in this case, In Cell A3 enter: =A1+A2 "asg2307" wrote: How do I get a "+" sign to show up when I do a formual =a1-b1. The minus sign shows up, but I would like to see the plus sign for positive results. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
showing plus sign
How about going into Format - Cells - Number, select Custom, and type in
+0;-0 and create your own personal Custom format? Good Luck! "asg2307" wrote: How do I get a "+" sign to show up when I do a formual =a1-b1. The minus sign shows up, but I would like to see the plus sign for positive results. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
showing plus sign
You could give it a custom format:
Format|Cells|number tab|custom category: +General;-General;0;@ (positive;negative;0;text) asg2307 wrote: How do I get a "+" sign to show up when I do a formual =a1-b1. The minus sign shows up, but I would like to see the plus sign for positive results. Thanks -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
showing plus sign
If I understand correctly, you want the results of a formula to show either a
negative or positive sign before the number... so if A1-B1 where a negative 2, it would look like this: -2 and if it were positive it would look like this: +2. If that's what you are looking for, select the range containing your results and choose Format, cells, number tab. Select Custom as the number format (it's at the end of the list) and enter this: +#,##0.00;-#,##0.00;0.00 this custom format would display numbers with commas as needed, a decimal and two decimal places, with a + for positive and a - for negative and 0.00 for results of zero. If you need your results to appear differently, change the custom format accordingly. For example: +#,##0;-#,##0;0 would display with no decimal places, but with the positive and negative signs... and zero would simply be 0. Remember that formatting to reduce decimal places does NOT (usually) change the value, only the appearance. Good luck! "asg2307" wrote: How do I get a "+" sign to show up when I do a formual =a1-b1. The minus sign shows up, but I would like to see the plus sign for positive results. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I change the $ sign to a £ sign in an MS template? | Excel Worksheet Functions | |||
XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
-ve no with -1; positive with sign+ and 0 no sign? Tks. | Excel Worksheet Functions | |||
Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
In SUM cells the # sign keeps showing instead of total | Excel Discussion (Misc queries) |