What to do if E+ appears in the table

The solution to E appearing in the table: first open the table file that needs to be modified; then right-click the cell and click "Format Cells"; finally change the value to text in the category and save it.

Recommendation: "Excel Tutorial"

First of all, we need to understand that how to enter numbers into cells in the excel system The default format is "regular", and the number that can be fully displayed is 11 digits. When the value we enter exceeds 11 digits, it will be displayed in scientific notation. For example, 123456789123456 is displayed as 1.23457E 14.

So, when the cell format is set to "Number", the number of valid digits that can be fully displayed is only 15, and starting from the 16th digit is displayed as 0. For example, 12345678912345678 will be displayed as 12345678912345600. To fully display more than 11 digits, the cell format must be set to "Text".

The method to set the cell format is very simple. Right-click the cell to set the cell format. In the category, change the option from value to text and click OK.

There is another way to completely display the entered 15 or more digits. In addition to the above-mentioned method of setting the cell format to "text", you can also directly Enter an English single quotation mark (') into the cell first and then enter the number.

The above is the detailed content of What to do if E+ appears in the table. For more information, please follow other related articles on the PHP Chinese website!