Why do numbers in excel change to E+18 format?

Cause: The number is too long; Excel defaults to display numbers with more than 11 digits in scientific notation (E). Solution: 1. Before entering numbers, enter single quotes. At this time, the input cell will default to text format and the numbers will be fully displayed. 2. Set the cell to text format. 3. Set the data to numerical format.

#Everyone will encounter such a situation when entering data in excel. When the input data exceeds 11 digits, the data is displayed in scientific notation (E).

Example:

##What should we do when E appears? ? Let me introduce to you how to deal with it.

Solution:

Method 1: Before entering the number, enter the single quotation mark first. At this time, the input cell will default to text format and the number will be fully displayed. .

Method 2: Set the cell to text format

1. Click the right button of the mouse, the options menu will appear, click the "Format Cells" option, this We will see a dialog box.

#2. We select the "Text" format option, click the "OK" button, and then the data is fully displayed.

Method 3: Set the data to numerical format. If the data needs to be added, subtracted, multiplied and divided, the text format cannot be processed. You must Set the numeric format.

1. Right-click the mouse, select "Format Cells", and select the "Value" option.

2. If the entered value has a decimal point, we select the decimal place to be displayed in the decimal digits. We enter the value as the ID number, and there is no need to display the decimal point. Here We set it to 0. After setting OK, click the OK button.

#3. At this time, the data will be displayed completely. We can directly use the shortcut key CTRL 1 to quickly pop up the "Format Cells" dialog box without right-clicking.

Related learning recommendations:

excel basic tutorial

The above is the detailed content of Why do numbers in excel change to E+18 format?. For more information, please follow other related articles on the PHP Chinese website!