Why is there no 0 in the Excel table?

The reason why the Excel table does not have 0 is because the format of the cells has not been changed. The solution: first open the EXCEL software; then right-click the table where you need to add "0"; then click Set Cell Format, and Select "Text" in the pop-up dialog box; finally re-enter 0.

The operating environment of this article: windows7 system, Microsoft Office Excel2016, DELL G3 computer

The main reason is because the format of the cells has not been changed, specifically The operation steps are as follows:

1. Open the computer, find and double-click the EXCEL2016 version software;

2. After opening the EXCEL2016 version software, add "0" when needed Click the right mouse button on the table to display the drop-down option;

3. After clicking the right mouse button, select the "Format Cells" command in the drop-down option;

4. After clicking to format the cells, in the pop-up dialog box, select "Text" in the lower left corner;

5. After selecting and confirming the text, you can enter numbers with "0" in the empty form. [Recommended learning: Excel tutorial]

The above is the detailed content of Why is there no 0 in the Excel table?. For more information, please follow other related articles on the PHP Chinese website!