How does an Excel table add + before a positive number?

A lot of people do not know how to use the + number in front of positive numbers in Excel, although this is a small problem but still baffled a lot of people, the following small series to teach you how to Excel table in front of a positive number plus +?

How does an Excel table add + before a positive number?

In the Excel cell, if you enter +2, the result is 2, not +2.

Some students say, first set into text, and then enter +2

The direct input value can be, but if the formula returns 2, this method cannot be used.

Some students said that in the formula, with "+" connected to the results, such as

= "+" & A2

However, if the result of A2 is-2, the result of the formula becomes +-2.

Well, blue does not rule out the use of formulas to achieve this goal, but it is very troubling. Here we use the custom Format method to add "+" before the positive number

Method of operation;

Select the cell or range for the setting, and press CTRL + Number 1 to open the Format Cells window. Number-Custom-enter in the right text box

"+" g/general format;-g/General format

Code Description: The g/common format is the default General number format for Excel.

Positive numbers the first two positions in the custom format are positive digits and the second is negative digits.

The results are shown in the following figure