Home  >  Article  >  Topics  >  Why does 3.50127E+17 appear when copying numbers in excel?

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

藏色散人
藏色散人Original
2020-03-17 13:57:0211600browse

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.

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

#2. After opening the document, select the ID card cell.

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

#3. After selecting the ID card data cell, right-click the mouse and select Format Cell.

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

#4. After entering the cell format setting, change the format to text and click OK.

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

#5. After the cell is changed to text, it can be turned into data form.

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

#6. You can also add a ' symbol before the data number.

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

#7. After adding this ' symbol, the data will not become E 17 format.

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn