Excel has numbers but cannot display them

The solution to the problem that there are numbers but cannot be displayed in excel: first select the data in question; then open [Set Cell Format]; and finally select [General Format] under the [Number] column.

Excel has numbers but cannot display them:

1. If the cell where the number is located is set to General format:

2. The number is displayed:

Solution: Set the cell format to In the regular format, the numbers are displayed

Related learning recommendations: excel basic tutorial

The above is the detailed content of Excel has numbers but cannot display them. For more information, please follow other related articles on the PHP Chinese website!