How to solve scientific notation in excel?

Recommended tutorial: "excel basic tutorial"

How to solve scientific notation in excel?

How to solve scientific notation in excel:

1. TRIM function auxiliary method

First Looking at the table below, the numbers stored in the cells in column A have all been converted to scientific notation. Now, we want to display the numbers in scientific notation completely.

Use column B as an auxiliary column and display it through the TRIM function.

As shown in the picture above, in cell B1, use the formula function: =TRIM(A1) In this way, the complete number display will be obtained. For other cells, drag down to get the result.

2. Cell formatting method

In addition to the above methods, we can also set the format of the cell so that the numbers are fully displayed.

First select the cell with scientific notation and perform the menu operation: "Format" → "Cell". The dialog box shown below pops up.

Select the "Number" tab, select "Custom" under the category, and directly enter a 0 on the right side of it, under "Type" .

Click "OK" to confirm and exit. In this way, the numbers in the cells with scientific calculation methods are completely displayed.

The above is the detailed content of How to solve scientific notation in excel?. For more information, please follow other related articles on the PHP Chinese website!