Office Guide丨How to enter the ± sign in Excel?

There is a problem that everyone has encountered. After entering numbers in Excel, when entering "+", "-", and "±" before the numbers, "-" can be displayed, "+" cannot be displayed, and "±" Can display but cannot complete text calculations . How can we solve it?

1. Input "+" before the number cannot be displayed.

Solution: Right-click -Set the cell format - custom add [+0;-0;0];

Set the custom format to consist of positive digits, negative digits, zero value digits, and text digits, that is, positive digits are added with a positive sign, negative digits are added with a negative sign, 0 or 0;

2. In excel, all special symbols can be input through the input method, but when a positive or negative sign is encountered, the calculation result will be affected, making it impossible to calculate.

Solution: right click - set cell format - custom add [±];

Finally, a reminder to everyone: the custom format cannot change the real value. You can clip and paste the values into the table if you need to convert them to real values.