How to Show "+" for positive and "-" for negative

E

Emil

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
 
A

Ashish Mathur

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
 
S

Satti Charvak

can try this also:

+#;-#

just tilt you head to the left and check the answer.
 
E

Emil

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.
 
E

Emil

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.
 
E

Emil

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
 
E

Emil

Thanks - that answered everything i needed and then some - soo easy now that
you spelled it out :)
 
D

David Biddulph

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.
 
S

Satti Charvak

Your are welocme.
Thanks for giving me chance to help you. Today is my first day in Microsoft
Excel Community.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top