How to change excel table numbers into e+

Numbers in an Excel table are displayed as e to indicate that the number is too large or too small to be displayed in the standard number format. The solution is: 1. Adjust the cell width; 2. Use scientific notation; 3. Increase the number of decimal places; 4. Use a custom number format; 5. Try to use the TEXT function; 6. Use the Power function; 7. Use LARGE function.

How to solve the problem that the numbers in the Excel table become e

Problem: In the Excel table The number is shown as e?

Answer: The number displayed as e indicates that the number is too large or too small to be displayed in the standard number format.

Solution:

1. Adjust the cell width: Double-click the right border of the cell or select the "Home" tab> Alignment group > Wrap Text.
2. Use scientific notation: On the Home tab >Number group, select Text. Then select Home tab >Number group >Scientific Notation.
3. Increase the number of decimal places: In the "Home" tab > "Number" group, click the "Increase the number of decimal places" button or use the "Format Cells" dialog box settings Number of decimal places.

4. Use a custom number format: On the Home tab >Number group, select Custom. Enter the following code:

   • For numbers greater than 10^12: 0,,,"0.
   • #"
   For numbers less than 10^-12:
0,,,"0.
5. ##E-00"

6. Try using the TEXT function:

   Enter the following formula in the cell (assuming the original number is in cell A1):

   <code>=TEXT(A1,"0.00E+00")</code>

7. Use the Power function:

   In Enter the following formula in the cell (assuming the original number is in cell A1):

   <code>=POWER(10,A1)</code>

Use the LARGE function: ###Enter the following formula in the cell (assuming the original number Numbers are in a range, such as A1:A10): ###

<code>=LARGE(A1:A10,1)</code>

######

The above is the detailed content of How to change excel table numbers into e+. For more information, please follow other related articles on the PHP Chinese website!