2. Set the cell data format and format multiple cells uniformly. You can select the cell where you want to enter numbers, and then right-click to select a format cell.
3. Select the text method. In number format, select text, and then click OK to save the settings so that the cells are set as text.
4. Test and enter a string of numbers. After setting the cell, enter the number, and the number format will be displayed automatically without conversion.
5. If you want to set many cells, you can select multiple cells at a time and set the cell format as text together.