After excel automatically sums, # appears and the data is not displayed. What's the matter?

The cell format is incorrect, and the specific solution is as follows:

1. First select the desired data cell.

2. Right-click and select the Cell Format dialog box in the pop-up dialog box.

3. In the Cell Format dialog box, select Numeric in the Category column, and then click OK.

4. Click OK, and you can see that there are values in the cells with formulas, indicating that the operation is successful.