How Excel sets the display number 0

How Excel sets the display number 0

Excel sets the tutorial for displaying the number 0 (i)

Step 1: The first case that the number 0 does not display is a single number "0", which is not visible when the cell is confirmed. This situation is due to a problem with the settings in Excel options. So, first click on "Excel Options".

Step 2: In Excel Options, find Advanced, and then step through the details of each setting, find the display options for this worksheet, and check the "show cells with 0 values 0" front.

Step 3: As shown in the following illustration, after you enter a single number 0, you can display it.

Excel sets the tutorial for displaying the number 0 (ii)

Step 1: In Excel, enter the ID card, phone number, and so on, often encounter the first number is zero, then the situation and just different, this time is not the problem of Excel options, but the cell format problem. First, you want to format the cell, right-click, and choose Format Cells.

Step 2: In the pop-up window, select the "Number" option, select the text in its category, which is to say that any input cell content will be displayed as text, although the input is a number, but is actually text, can not apply mathematical formulas to calculate, click OK.

Step 3: After the above operation, you can display 0, the specific effect see the figure below.

Word Tutorial

Excel Tutorials

PowerPoint Tutorials