Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - How to convert numerical values in excel tables into digital formats
How to convert numerical values in excel tables into digital formats
1, the simple and convenient method is to enter English' directly in front of the excel cell where the number is entered, and then enter the number, so that the excel cell is directly converted into text format, and the text format will not be automatically converted into a scientific counting method.

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.