Why does 3.50127E 17 appear when copying numbers in excel?
That’s because the number entered is too large and the system Automatically changed to scientific notation.
Recommended: "excel tutorial"
1. Open the Excel document on the computer.
#2. After opening the document, select the ID card cell.
#3. After selecting the ID card data cell, right-click the mouse and select Format Cell.
#4. After entering the cell format setting, change the format to text and click OK.
#5. After the cell is changed to text, it can be turned into data form.
#6. You can also add a ' symbol before the data number.
#7. After adding this ' symbol, the data will not become E 17 format.
The above is the detailed content of Why does 3.50127E+17 appear when copying numbers in excel?. For more information, please follow other related articles on the PHP Chinese website!