If you want to make Excel display a + and – for positive and negative number values create a Custom Format
A | B | C | < B format rule > | < C format rule > | |
---|---|---|---|---|---|
1 | 12 | +12 | +12.00 | +0;-0 | +0.00;-0.00 |
2 | -10 | -10 | -10.00 | +0;-0 | +0.00;-0.00 |
3 | 7 | +7 | +7.00 | +0;-0 | +0.00;-0.00 |
4 | -5.4 | -5.4 | -5.40 | +0;-0 | +0.00;-0.00 |
5 | 8.691 | +9 | +8.67 | +0;-0 | +0.00;-0.00 |
Select the cell(s), (or entire column/row), and open Format Cells, then select Custom and in Type enter format as required as shown above.
Note: if you’re using decimal places, values will round up or down as shown in example
Leave a Reply