How to cancel the scientific notation displayed in excel in batches

How to cancel the scientific notation displayed in excel in batches

Author: iamlaosong

When copying a text document to an EXCEL file, all the numbers in one column are converted into scientific notation. These numbers are actually bar code numbers and do not need to be computed. How can we cancel the scientific calculation method, what if the number is displayed as the original one? The general method is as follows:

1. Set the cell format to text format. 2. Convert the cell to text. Double-click the cell. 3. Add the symbol "'" before the number (no quotation marks, note that it is in the English input method)

However, when the data volume is large, it is obvious that the processing efficiency is too low. The partitioning method can quickly process all cells.

1. Select the columns to be processed and click the sort button or menu. 2. Click "Next" until the format is selected. For details, see. 3. Select "text" format, click "finish.