Display plus sign

[Charlie]

Is there any way to format a row of cells so that a plus
sign displays in front of all positive numbers. My
spreadsheet calculates the percentage of change in a value
from a prior year and I just think it would be clearer to
a casual observer to see the "+" and "-" signs in front of
each number. It is easy, of course, to have the minus
signs displayed, but I'm at a loss to figure out how to do
the same thing with plus signs.

 

[mzehr]

Hi Charley

Try Custom Number formats
+# - modify to suit

 

[AlfD]

Hi!

Doesn't this create problems if value is negative?

Al

 

[BenjieLop]

This is more of a "curiosity" inquiry ...

Why do you need to put a "+" sign in front of a positive number? Isn'
this redundant?

 

[mzehr]

Hi Alf,
Good catch.
Try some variant of +#,###_);(#,###)

Mike

 

[AlfD]

Hi!

It's beginning to get messy.

Is there anything wrong with using colours (on screen) or bold fac
type (if it's printed)?
Both can be eyecatching and both can be done using conditional format.

I know that OP asked for plus signs. I just think there are bette
ways...

Al

 

[Charlie]

Not when you factor in the IQ of the people I work for.

 

[Alex Delamain]

How about this one:

=IF(A1<0,A1,"+"&+A1)

The one drawback is that if you want to use that cell in late
calculations you will need to use +value(B1) instead of +B

 

[AlfD]

Charlie:

I feel for you!

But if it's as bad as that, maybe they'll believe if you say it can'
be done...?

Al

 

[Ron Rosenfeld]

I feel for you!

But if it's as bad as that, maybe they'll believe if you say it can't
be done...

Why should he say that when it's simple to do?


--ron

 

[Andy]

What Mike said:

Try some variant of +#,###_);(#,###)

I learn something every time I come here. So the first format is for
positive numbers and the second is for negative.

+#,##0;-#,##0

entered in FormatCells > Custom does what you want, "+" for positive
numbers and "-" for negative numbers

 

[Charlie]

Thanks to all. Lots of great help here!!!

-----Original Message-----
What Mike said:


I learn something every time I come here. So the first format is for
positive numbers and the second is for negative.

+#,##0;-#,##0

entered in FormatCells > Custom does what you want, "+" for positive
numbers and "-" for negative numbers


.