Why does 3.50127E+17 appear when copying numbers in excel?

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!