How to add green in the upper left corner of excel numbers
- 藏色散人Original
- 2020-02-26 09:55:0020937browse
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!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：How to set gray shading in ExcelNext article：How to set gray shading in Excel