How to deal with numbers exceeding 15 digits in Excel

How to deal with numbers exceeding 15 digits in excel?

Open the excel worksheet as an example.

Recommendation: "excel tutorial"

In the regular cell format, numbers that exceed the number of digits entered will automatically be converted to Displayed in scientific notation.

Click the drop-down option of the cell shortcut settings and select the text format.

#If you enter more than 15 digits, the mantissa will not become 0.

Or if you enter the ' symbol in English before entering the numbers, you can force the numbers to be converted to text display.

Isn’t it very simple, why don’t you learn it quickly

The above is the detailed content of How to deal with numbers exceeding 15 digits in Excel. For more information, please follow other related articles on the PHP Chinese website!