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.

#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!