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!