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.
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
+0;-0;0
Jun 28, 2011 at 8:47