How to enter numbers exceeding 18 digits in Excel?

php editor Baicao introduces you how to enter numbers with more than 18 digits in Excel tables. In daily work, we sometimes need to process numbers with more than 18 digits, but Excel only displays the first 15 digits by default, and numbers with more than 15 digits are automatically converted to scientific notation. If you want to enter a complete long number, you can add a single quotation mark before the cell, or set the cell format to text format, so that you can completely enter and display numbers exceeding 18 digits.

1. Use the number label to select the cell (area) where you need to enter an 18-digit number, open the "Format Cells" dialog box, enter the "Number" tab, select the "Text" option under "Category", confirm to exit, and then enter the number. That’s it.

[Be sure to set the format before entering the numbers].

2. When entering an 18-digit number, add a single quotation mark "‘" in English in front of the number to fully display the number (the single quotation mark will not be displayed after confirmation).

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