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!