Display plus sign

  • Thread starter Thread starter Charlie
  • Start date Start date
C

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.
 
This is more of a "curiosity" inquiry ...

Why do you need to put a "+" sign in front of a positive number? Isn'
this redundant?
 
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
 
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
 
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
 
What Mike said:
Try some variant of +#,###_);(#,###)
Click to expand...

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


.
Click to expand...
 
Back
Top