What should I do if Excel table 0 cannot be displayed?

What should I do if Excel table 0 cannot be displayed?

As shown in the picture below, we want to hide the 0 in the excel cell, as shown in the picture on the right.

Recommended: "excel tutorial"

The author is using the office 2007 version, click the "OFFICE button- EXCEL Options - Advanced - Display options for this worksheet - Uncheck "Display zeros in cells with zero values". As shown below:

If the Excel version you are using is version 2003, click "Tools-Options-View-Window Options-Remove the check mark before the zero value"

Note: The setting of this method is for all cells of the current worksheet Make settings.

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