Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
I have a cell which fluctuates based on its formula between positives and
negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
Hi,
Select the cells where you want to apply the formatting and then in Format Cells Number Category Custom Type, enter the following: "+"#,##0_);(#,##0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Emil" wrote in message ... I have a cell which fluctuates based on its formula between positives and negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
can try this also:
+#;-# just tilt you head to the left and check the answer. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Ashish Mathur" wrote: Hi, Select the cells where you want to apply the formatting and then in Format Cells Number Category Custom Type, enter the following: "+"#,##0_);(#,##0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Emil" wrote in message ... I have a cell which fluctuates based on its formula between positives and negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
hmm, not quite working - with you formula it does show the + sign now; but
for the negative #'s it shows (number) without the negative sign. "Ashish Mathur" wrote: Hi, Select the cells where you want to apply the formatting and then in Format Cells Number Category Custom Type, enter the following: "+"#,##0_);(#,##0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Emil" wrote in message ... I have a cell which fluctuates based on its formula between positives and negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
Well that seems to work for the straight up # with no decimals. (Thanks!)
Now my next problem is how to do this same thing but with a percentage with 3 decimal places. "Satti Charvak" wrote: can try this also: +#;-# just tilt you head to the left and check the answer. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Ashish Mathur" wrote: Hi, Select the cells where you want to apply the formatting and then in Format Cells Number Category Custom Type, enter the following: "+"#,##0_);(#,##0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Emil" wrote in message ... I have a cell which fluctuates based on its formula between positives and negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
Hi,
It wont show the negative sign. It will just show the negative number in brackets. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Emil" wrote in message ... hmm, not quite working - with you formula it does show the + sign now; but for the negative #'s it shows (number) without the negative sign. "Ashish Mathur" wrote: Hi, Select the cells where you want to apply the formatting and then in Format Cells Number Category Custom Type, enter the following: "+"#,##0_);(#,##0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Emil" wrote in message ... I have a cell which fluctuates based on its formula between positives and negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
try this :
+#.000%;-#.000% -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Emil" wrote: Well that seems to work for the straight up # with no decimals. (Thanks!) Now my next problem is how to do this same thing but with a percentage with 3 decimal places. "Satti Charvak" wrote: can try this also: +#;-# just tilt you head to the left and check the answer. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Ashish Mathur" wrote: Hi, Select the cells where you want to apply the formatting and then in Format Cells Number Category Custom Type, enter the following: "+"#,##0_);(#,##0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Emil" wrote in message ... I have a cell which fluctuates based on its formula between positives and negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
Actually Neither of these formula's worked.
1 cell is a # i.e. (1.111) 1 cell is a % i.e. (1.111%) Both have 3 decimal places, i just happened to hit it where all of the #'s were of the same value. (bad luck) I would like to see +1.111 or -1.111 & accordingly either +1.111% or -1.111%. So i need to re-ask the question and hopefully tailor my question better. How can I have a + sign show up when the value is positive. When the value is negative, this works - it automatically shows the "-" sign at the beginning of the value. I figure there has to be a rather simple way to show a + if the value is positve just like it automatically shows a - if the value is negative. I hope this helps explain better what I am looking for... Thanks Again, Emil "Emil" wrote: I have a cell which fluctuates based on its formula between positives and negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
Thanks - that answered everything i needed and then some - soo easy now that
you spelled it out :) "Satti Charvak" wrote: try this : +#.000%;-#.000% -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Emil" wrote: Well that seems to work for the straight up # with no decimals. (Thanks!) Now my next problem is how to do this same thing but with a percentage with 3 decimal places. "Satti Charvak" wrote: can try this also: +#;-# just tilt you head to the left and check the answer. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Ashish Mathur" wrote: Hi, Select the cells where you want to apply the formatting and then in Format Cells Number Category Custom Type, enter the following: "+"#,##0_);(#,##0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Emil" wrote in message ... I have a cell which fluctuates based on its formula between positives and negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
If you have some cells in one format (Number or General), and some cells in
another format (Percentage), you'll have to give your + specification to each of the groups of cells separately. -- David Biddulph "Emil" wrote in message ... Actually Neither of these formula's worked. 1 cell is a # i.e. (1.111) 1 cell is a % i.e. (1.111%) Both have 3 decimal places, i just happened to hit it where all of the #'s were of the same value. (bad luck) I would like to see +1.111 or -1.111 & accordingly either +1.111% or -1.111%. So i need to re-ask the question and hopefully tailor my question better. How can I have a + sign show up when the value is positive. When the value is negative, this works - it automatically shows the "-" sign at the beginning of the value. I figure there has to be a rather simple way to show a + if the value is positve just like it automatically shows a - if the value is negative. I hope this helps explain better what I am looking for... Thanks Again, Emil "Emil" wrote: I have a cell which fluctuates based on its formula between positives and negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show "+" for positive and "-" for negative
Your are welocme.
Thanks for giving me chance to help you. Today is my first day in Microsoft Excel Community. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Emil" wrote: Thanks - that answered everything i needed and then some - soo easy now that you spelled it out :) "Satti Charvak" wrote: try this : +#.000%;-#.000% -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Emil" wrote: Well that seems to work for the straight up # with no decimals. (Thanks!) Now my next problem is how to do this same thing but with a percentage with 3 decimal places. "Satti Charvak" wrote: can try this also: +#;-# just tilt you head to the left and check the answer. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Ashish Mathur" wrote: Hi, Select the cells where you want to apply the formatting and then in Format Cells Number Category Custom Type, enter the following: "+"#,##0_);(#,##0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Emil" wrote in message ... I have a cell which fluctuates based on its formula between positives and negatives. (I use Excel 2007 if that matters). When the value is negative it always shows the "-". How can I make this also show the "+" if the value is positive? Thanks in Advance, Emil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
conditional formula to show "open" or "closed" | Excel Worksheet Functions |