Excel retains two digit decimal functions

First open **Click on the file, then click on Options, click on it, tick Automatically set the decimal point, and finally modify the number of digits to 2, detailed steps:

1. First of all, open **Click on the file.

2. Then click on Options.

3. Click. 4. Check to set the decimal point automatically.

5. Finally, modify the number of digits to 2.

Open**, select a cell with decimal or the whole row or the whole column or the whole**, right-click the drop-down menu and select "Format Cells", pop up "Format Cells" - number - number - number of decimal places to set the value 2, click "OK".

Use the round function to round round, e.g. round(,2)=

rounddown, not carrying, e.g.: rounddown(,2)=;

roundup, e.g. roundup(

In the process of excel use, it is often necessary to add numbers.

Rounding to two decimal places, this article explains how.

Keep the numbers to two decimal places in Excel according to different needs.

Turn on step-by-step reading mode.

Tool Material: Microsoft Office - Excel

Detailed description of the method:

The first method: format cells.

To select the area, right-click [

Format Cells] - 【

Value] - [two decimal places] is sufficient.

Features: The Excel cell is displayed with two decimal places, but the value of the actual cell remains unchanged.

The second method: click the button on the menu bar to adjust.

Features: The Excel cell is displayed with two decimal places, but the value of the actual cell remains unchanged.

The third method is to keep two decimal places with the round function.

Select cell C2 and enter the function:

round(a2,2), drop down to fill, and adjust the number of decimal places.

Features: Values have been turned into real rounding results, e.g. the contents of cell C2, which are involved in the calculation, not the original. You can also copy the results and paste them into the original area to replace them.

The fourth method is to use the text function to keep two decimal places.

Selected. C2 cell, input function:

text(a2,""), drop down to fill it.

Features: The text number that returns two decimal places is retained, if you want to become a number, you can change it to:

text(a2,"")。It is already when participating in the calculation.

Rounded figures.

Fifth method: Use the clipboard or notepad method to become a truly rounded number.

After formatting the cells according to the first or second method, copy, paste to Notepad, and then cut and paste back to Excel**; Or.

Copy, and select [

Clipboard] pasting is also possible.

The sixth method: the display accuracy method becomes the number after true rounding.

After formatting the cells according to the first or second method, click [

office button] - [

Excel Options] - [

Advanced - When this workbook is calculated - Select

Set the precision to the displayed precision, and then click [

OK button.

Note: When performing this setting, it is best to open only the single workbook that needs to be set, and uncheck this option when you are done.

The data in excel needs to use formulas to keep 2 decimal places, how to keep 2 decimal places with functions? The next is the method I brought to you to keep 2 decimal places with formulas in excel for your reference.

Excel method of keeping 2 decimal places with formulas (1).Step 1: Select cell C2, enter the function: =round(A2,2), drop down to fill, and adjust the number of decimal places.

Step 2: The values have been turned into real rounding results, such as the contents of cell C2, which are involved in the calculation, not the original. You can also copy the results and paste them into the original leased area for replacement.

Excel uses the formula to retain the square loss method of 2 decimal places (2).Step 1: Select cell C2 and enter the function: =text(A2,""), drop down to fill it.

Step 2: What is returned is a text-based number after retaining the megadecimal places of the two brigades, if you want to change it to a number, you can change it to:

Click Format Cell, select the value, set the number of decimal places 2, and the selected content will be automatically rounded to two decimal places. The specific steps are as follows:

Tools Raw materials: ASUS Redolbook 14, Windows 10, Excel 2020

1. Click Format Cells.

Excel**, after selecting the content, click the mouse on the right and click "Format Cells".

2. Select a number.

Categorize and select the "Number" option.

3. Set the number of decimal places.

Set the number of decimal places to "2" and click OK.

4. Achieve results.

The selected content will be automatically rounded to two decimal places.

Enter: =fixed(b1,2) and press Enter to sell the bundle.

The fixed function refers to a custom decimal format that rounds the value to a specific number of digits, structure: =fixed

Often in the process of using Excel, we often need to keep Liang Lu numbers to two decimal places, so let's explain how to keep two decimal places in Excel.

02 After entering the interface, enter the "Number" interface, select "Value" in the category, adjust to two decimal places, and click OK.

03 The next value will be two decimal places.

01 Find the three symbols in the picture in the start menu bar to adjust.

01 Input function: =round(d2,2), click enter to keep it to two digits.

01 Input function: =text(d2,""), click enter to keep the rubber boy to double digits.

01 Click "Office Button" and then click "Excel Options" to enter the "Advanced" option, select "When calculating this workbook", click the option of "Set the precision to the displayed precision", and finally click "OK" to set it successfully.

01 After formatting the target as a cell, copy and paste it into Notepad, and finally cut and paste it back into Excel.

If this experience helps you, give it a thumbs up!