How to display xx in Excel?

How does x xx x appear in excel?

x.xx x

This expression is an expression in scientific notation. Select the cell or range of cells where the number is located, right-click, select "Format Cells", then select "Scientific Notation", and finally click "OK" to format the number in scientific notation.

EXCEL will display numbers entered with more than 12 digits in scientific notation, such as 1.23457E 17, which means 1.23457 times 10 raised to the 17th power

If the number string written exceeds 15 digits, because the numerical precision of EXCEL is 15 digits, the part of the number string exceeding 15 digits will be padded with 0

Therefore, the cell format should be set before entering a long numeric string.

Methods as below:

Method 1. Select the cell or cell range where you want to enter the numeric string----right-click-----Set the cell format (you can also click "Format" and select "Cell" or press CTRL 1, and the Cell Format dialog box), -----Number-----Text------OK

Method 2. When entering a numeric string into the cell, first enter the ' sign (half-width single quotation mark), such as: '123456789123456789, so that the cell will write numbers in text format by default.

Why is the excel table number too long and the last number cannot be displayed

To enter more than 15 digits in the EXCEL table and have it display normally (according to the actual number of digits), there are three methods to achieve this based on the data recording process:

1. First enter an English single quotation mark and then enter the number.

2. Select the number area, execute "Format/Cell/Number/Category/Text" and then "OK", then enter the number directly. Note: You need to click on the text first, and then enter the number; if you have already entered the number, clicking the text again at this time will not change the 0 after more than 15 digits into other numbers you want to display.

3. For very long numeric strings input from other forms (pasted), they can only be modified individually. Enter an English single quotation mark at the front (first) of each numeric string, and then modify 15 digits before being replaced by 0. Replacement number.

The derived question is: Since the result of the above three methods is that a green triangle appears in the upper left corner of these cells, is there an operation method that can directly set the cells in the specified area to this format?

The above is the detailed content of How to display xx in Excel?. For more information, please follow other related articles on the PHP Chinese website!