How to add green in the upper left corner of excel numbers

How to add green in the upper left corner of excel numbers?

The small green label in the upper left corner of the number in excel is: When the cell format is set to text format, it will be generated when the number is entered in the cell.

The green dots in the upper corner are numbers in text format, which are generally used to enter long strings of numbers such as ID cards.

Method:

Set the cell to text format, select the cell range to be set, in this example set A1:A10, select A1:A10-->right-click-> ;Set cell format-->Text-->OK.

The above is the detailed content of How to add green in the upper left corner of excel numbers. For more information, please follow other related articles on the PHP Chinese website!