What should I do if the 0 entered in the Excel table is not displayed?

When you enter the number 0 in excel, sometimes it cannot be displayed. What is the reason for this? The specific solutions are divided into two types according to the reasons.

Inputting a single number 0 does not display the solution:

The first case where the number 0 cannot be displayed is when a single number "0" is entered. After confirmation, the cells cannot be displayed. This situation is due to a problem with the settings in the excel options. So, first click on “excel options”.

In "excel options", find "Advanced", and then gradually observe the specific content of each setting, find "Display options for this worksheet", and change "Have Check "Display zero in cells with zero values".

0 is not displayed in the first digit Solution:

Enter ID card, phone number, etc. in Excel, often You will encounter a situation where the first number is zero. The situation at this time is different from the previous one. This time it is not a problem with the Excel options, but a problem with the cell format. First, you need to format the cells, right-click and select "Format Cells".

In the pop-up window, select the "Number" option and select text under its category. This actually means that any content entered into the cell will be displayed in text form. , although the input is a number, it is actually text and mathematical formulas cannot be applied for calculation. Click OK.

After the above operations, you can enter numbers starting with 0.

Recommended: Excel Basic Tutorial

The above is the detailed content of What should I do if the 0 entered in the Excel table is not displayed?. For more information, please follow other related articles on the PHP Chinese website!