Home  >  Article  >  Topics  >  How to display numbers in Excel in ID card

How to display numbers in Excel in ID card

藏色散人
藏色散人Original
2020-04-25 09:27:565350browse

How to display numbers in Excel in ID card

How to display numbers in Excel in ID card

First open the excel table.

How to display numbers in Excel in ID card

Let’s take the following numbers as an example. Looking at the picture, you can see that normally all of them cannot be displayed after being entered.

How to display numbers in Excel in ID card

The first method is to change the input method to English, and then enter the "'" single quote symbol in front of the number. Then enter the number, and the number will be displayed

How to display numbers in Excel in ID card

The second method is to right-click the cell with our number and select Format Cell

How to display numbers in Excel in ID card

Select numbers and text. If you then enter numbers, all the numbers in the set cells will be displayed.

How to display numbers in Excel in ID card

The above is the detailed content of How to display numbers in Excel in ID card. 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