Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 49
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 37
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 49
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 49
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 37
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 49
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 49
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 37
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
conditional formula to show "open" or "closed" SBS Excel Worksheet Functions 6 January 28th 06 02:48 AM


All times are GMT +1. The time now is 03:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"