Home>Article>Topics> What should I do if the excel formula changes to 0 after pressing Enter?

What should I do if the excel formula changes to 0 after pressing Enter?

coldplay.xixi
coldplay.xixi Original
2020-06-18 09:12:31 28905browse

What should I do if the excel formula changes to 0 after pressing Enter?

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.

What should I do if the excel formula changes to 0 after pressing Enter?

#2. Then select the first two number cells.

What should I do if the excel formula changes to 0 after pressing Enter?

#3. Then click the exclamation mark button that pops up.

What should I do if the excel formula changes to 0 after pressing Enter?

4. Then click to select Convert to Number.

What should I do if the excel formula changes to 0 after pressing Enter?

5. The result is as shown in the figure, so the correct result is displayed.

What should I do if the excel formula changes to 0 after pressing Enter?

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