What to do if the Excel order number changes to E+17 What to do if the Excel order number changes to E+17

Many e-commerce friends use Excel tables to record all product transaction information. However, when filling in the order number in the cell, it automatically changes to the E+17 format. Faced with this problem, many people I don’t know how to adjust it to display the correct content, so in response to this problem, the content of this software tutorial is here to answer the majority of users, hoping to bring help to you.

Solution to the Excel order number becoming E+17: 1. Enter a long number. First open the material file, click on the E2 cell to enter the order number in the picture, and hit Enter, we will Found that the default has become 2.11224E+17.

2. Set the cell format

First, we select the order number data in column E, press the Ctrl+1 shortcut key, the cell format dialog box pops up, and select the numerical option under the category Card, manually change the number of decimal places to 0, and after hitting Enter, we will find that the E+ is gone and all the numbers in the product number are displayed in the cells normally.

The above is the detailed content of What to do if the Excel order number changes to E+17 What to do if the Excel order number changes to E+17. For more information, please follow other related articles on the PHP Chinese website!