What should I do if all the numbers in the excel table cannot be displayed?

First we select the cell where we want to enter the number, right-click and select Format Cells

Open the cell format window, Select the text under Category in the Number tab and click OK.

Another method is to enter the number ' (quote mark in English) in front of the cell, for example: '12345678945612301, so that the cell will By default, the unit is in text mode, and the numbers will be displayed in full.

Recommended related tutorials: excel tutorial

The above is the detailed content of What should I do if all the numbers in the excel table cannot be displayed?. For more information, please follow other related articles on the PHP Chinese website!