Home > Topics > excel > body text

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

藏色散人
Release: 2020-02-26 09:55:00
Original
20892 people have browsed it

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.

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

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!

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template