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

