Home  >  Article  >  Topics  >  What should I do if the number 0 is not displayed when I enter it in Excel?

What should I do if the number 0 is not displayed when I enter it in Excel?

藏色散人
藏色散人Original
2020-03-05 09:10:1423484browse

What should I do if the number 0 is not displayed when I enter it in Excel?

What should I do if the number 0 is not displayed when I enter it in Excel?

Enter the number 0 in cell A1, and the result cell displays nothing.

Recommended: "excel tutorial"

What should I do if the number 0 is not displayed when I enter it in Excel?

When encountering this situation, click "File" - "Options" - " advanced".

What should I do if the number 0 is not displayed when I enter it in Excel?

Find "Display options for this worksheet" in the advanced page.

What should I do if the number 0 is not displayed when I enter it in Excel?

Check "Show zero in cells with zero values" and click "OK".

What should I do if the number 0 is not displayed when I enter it in Excel?

The above is the detailed content of What should I do if the number 0 is not displayed when I enter it in Excel?. 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