How to truly retain two decimal places in Excel How to truly retain two decimal places in Excel

How to retain two decimal places in Excel Excel is a powerful spreadsheet software, but some users encounter the problem of retaining two decimal places. Excel may truncate trailing zeros when displaying to exactly two decimal places is required. To solve this problem, this tutorial will provide detailed steps to help you truly preserve two decimal places. PHP editor Baicao has carefully compiled a variety of methods, which are simple and easy to understand, ensuring that the number of decimal places is accurately retained.

The first method: Format cell method

Select the area, right-click the mouse-[Set cell format]-[Value]-[Two decimal places] That’s it.

Features: Excel cells are displayed with two decimal places, but the actual cell value remains unchanged.

Second method: Click the button on the menu bar to adjust

Features: excel cells What is shown in is retained to two decimal places, but the actual cell value has not changed.

Third method: Use ROUND function to retain two decimal points

Select cell C2 and enter the function: =ROUND (A2, 2), drop down to fill, and adjust the number of decimal points.

Features: The numerical value has become a true rounded result. For example, the content of cell C2 is 1.35 when participating in the calculation, not the original 1.345. You can also copy the result and paste it into the original area to replace it.

Fourth method: Use the TEXT function to retain two decimal points

Select cell C2 and enter the function: =TEXT( A2, 0.00), just drop down and fill in.

Features: What is returned is a text number with two decimal places. If you want to turn it into a number, you can change it to:

=--TEXT (A2, 0.00). It is already a rounded number when participating in the operation.

The fifth method: Use the clipboard or notepad method to turn it into a truly rounded number

After formatting the cells according to the first or second method, copy and paste into notepad, then cut and paste back to the excel table; or copy and select [Clipboard] to paste.

Sixth method: Use the display precision to turn it into a truly rounded number

Follow the After setting the cell format in the first or second method, click [Office Button]-[Excel Options]-[Advanced]-[When calculating this workbook]-select [Set precision to displayed precision], after completing the settings Click the [OK] button.

Note: When performing this setting, it is best to only open a single workbook that needs to be set, and uncheck this option after the setting is completed.

The above is the detailed content of How to truly retain two decimal places in Excel How to truly retain two decimal places in Excel. For more information, please follow other related articles on the PHP Chinese website!