What should I do if the excel formula changes to 0 after pressing Enter?
- coldplay.xixiOriginal
- 2020-06-18 09:12:3128981browse
What should I do if the excel formula changes to 0 after pressing Enter?
Solution for excel formula to change to 0 after pressing enter:
1. First turn on the computer, open excel, enter two numbers in it, and then Perform the summation of the formula and find that the result is 0.
#2. Then select the first two number cells.
#3. Then click the exclamation mark button that pops up.
4. Then click to select Convert to Number.
5. The result is as shown in the figure, so the correct result is displayed.
Recommended tutorial: "excel basic tutorial"
The above is the detailed content of What should I do if the excel formula changes to 0 after pressing Enter?. 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 add watermark in excelNext article：How to add watermark in excel