Current location - Trademark Inquiry Complete Network - Trademark inquiry - How to set excel so that the values ??when opening excel are not displayed in scientific notation.
How to set excel so that the values ??when opening excel are not displayed in scientific notation.

The steps to cancel scientific notation are as follows:

Required materials: computer, Excel.

1. Here we take Excel2007 as an example. First select the cells you want to convert in the table.

2. Then click "Data" in the navigation bar.

3. Click "Column" in the "Data" column.

4. Select "Delimiter" in the first interface of sorting, and then click "Next".

5. Select "Tab key" for the second interface separator symbol, select "Comma" for the text recognition symbol, and then click "Next".

6. In the third interface column, select "Text" for the data format, and then click "Finish".

7. Finally, return to the form, and you will be able to see that the selected data has canceled scientific notation.