How can I display a '+' or '-' sign in front of a result using cell formating?

Question

I'm subtracting figures and I need to show whether the result is negative or positive.

Stumped as to how to make the '+' or '-' sign appear using cell formatting. Minus is automatic, I presume, but the positive I'm struggling with.

Mike Fitzpatrick · Answer 1 · 2011-06-28 08:36:11Z

up vote 2 down vote accepted

Use a custom number format for your cells, such as:

"+"0;"-"0;0

displays -1, 0, 1 as

-1, 0, +1

or

"+"0.00;"-"0.00;"No change"

displays -1, 0, 1 as

-1.00, No change, +1.00

answered Jun 28 '11 at 8:36

2

Actually the "" marks around the + - are not needed. Just use +0;-0;0 – chris neilsen Jun 28 '11 at 8:47

Therefore could you use +??.??;-??.??;??.??. Which I hope would allow for alignment and show the +/- symbols? – Mike Jun 28 '11 at 10:59

feedback

1 Answer