excel numbers retain two decimal places

How to retain 2 decimal places after the decimal point in excel?

In EXCEL to retain two decimal places after the decimal point of the method and the specific steps are as follows, to wps in EXCEL as an example to demonstrate.

1, the computer to find the wps software icon, double-click to enter, as shown in the figure below, enter the next page.

2, in wps to find and open the need to operate the EXCEL form file, as shown in the figure below, enter the next step.

3, select the need to set the cell right-click the invoice, in the pop-up Setting Options dialog box, click on the “Set Cell Format” option, as shown in the figure below, enter the next page.

4, in the pop-up Setting Options dialog box, select “numerical value”, the “number of decimal places” value to 2, as shown in the figure below, enter the next step.

5, and then click on the lower-right corner of the OK button, as shown in the figure below, to the next page.

6, then you can see the number of cells has been changed to retain two decimal places, as shown in the figure below, to complete all

Part of the operation.

excel retain two decimal

Often we use Excel in the process, often need to retain the number of two decimal points, the following we will explain how to retain the number of two decimal points in excel it.

Method 1: cell formatting method 01

As shown, this is the original data, select the dialog box needs to be set up, click the right mouse button, click on “cell formatting”.

02

After entering the interface, enter the “digital” interface, select “numerical value” in the classification, adjusted to two decimal places, click OK.

03

The next value will become two decimal places.

Method 2: Adjust the button on the menu bar01

Find the three symbols in the picture in the Start menu bar and you can adjust it.

Method 3: Use the ROUND function 01

Enter the function: = ROUND (D2,2), click enter to retain two digits.

Method 4: Use TEXT function 01

Input function: = TEXT (D2, “0.00”), click enter can be retained to two digits.

Method 5: show the accuracy of the quasi-method.01

Click the “Office button” and then click “Excel Options” to enter the “Advanced” option, select “Calculate this workbook when”. “Calculate this workbook”, click on “set the precision to the precision of the display” option, and finally click on “OK” can be set successfully.

Method 6: Cutting Board or Notepad method 01

Set the target cell format, copy and paste to Notepad, and then cut and paste back to the excel table on it.

Special Note

If this experience helps you, just click a like!