What should I do if the number 0 is not displayed when I enter it in Excel?
- 藏色散人Original
- 2020-03-05 09:10:1423529browse
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"
When encountering this situation, click "File" - "Options" - " advanced".
Find "Display options for this worksheet" in the advanced page.
Check "Show zero in cells with zero values" and click "OK".
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
Previous article：How to deal with numbers exceeding 15 digits in ExcelNext article：How to deal with numbers exceeding 15 digits in Excel