# How to make data retain two decimal places without change

### How do I keep the two valid digits after the decimal point unchanged?

Take two digits directly after the decimal point and round the third digit.

Keeping two decimals and keeping two digits are not the same, for example: 1.0023, keeping two decimals is 1.00, keeping two digits is 1.0. Valid digits are the digits from the first non-zero digit of the number up to the end digit of the number are called the valid digits, for example, there are three valid digits of 0.618, which are 6, 1, and 8.

How to keep two digits after the decimal point unchanged? p>

Methods of retaining valid numbers

(1) When retaining n valid numbers, if the n+1th digit ≤ 4 is rounded off.

(2) When retaining n valid numbers, if the n+1st digit ≥ 6, then the nth digit is rounded up to 1.

(3) When retaining n valid numbers, if the n+1st digit = 5 and followed by any digit of 0, then the nth digit is rounded up to the next digit if it is an even number, and 1 is added to the next digit if the nth digit is an odd one; if the n+1st digit = 5 and followed by any digit which is not 0, then whatever the nth digit is, then the next digit is rounded down to 1; if the n+1st digit = 5 and followed by any number not 0, then whatever the nth digit is, then the next digit is rounded down to 1. If the n+1th digit = 5 and there is any digit after it that is not 0, then 1 is added regardless of whether the nth digit is odd or even.

### Cell to retain two decimal how to set

Often deal with data often encountered in excel after the decimal point longer numbers, if we only need to retain the decimal point after two how to do it? Look at this article, not only teach you to retain excel decimal point after two, but also teach you how to use excel to retain two decimal methods. One is not to change the size to retain two decimal places, the other is to round up to retain two decimal places.

excel retain the decimal after two methods:

Do not change the size of the retained two decimal

1, do not change the size of the value, only change the format of the cell, as shown in the figure below, select the data cell, right-click, select Set Cell Format in the menu.

2, in the Set Cell Format interface on the left side of the selection of values, the right side of the number of decimal places changed to 2, click OK.

3, the result is to show only two decimal 12.35.

excel retains two decimal methods:

Rounding method to retain two decimals

1, by rounding to retain two decimals, which changes the size of the value. In the cell to the right of the data cell enter the formula = round (A1, 2)

2, press the Enter key later is the result of rounding 12.35.

Note:

The first method does not change the size of the value, only change the format

The second method is to round off to retain two decimal places, so the value of the size of the value has undergone a changed.

excel how to convert the unit to the number of ten thousand dollars, and retain two decimal places? The method is very simple, come and learn it.

Methods

1, first open the excel table, enter some numbers.

2, enter the formula = text = TEXT (G2, “0.00”) & “million dollars”).

3, press Enter and the results appear.

4, and finally hold ctrl + enter to update all the data.

5, if the unit plus dollars, the suffix is per hour, the formula is as follows: = TEXT (G2, “\$0.00”) & “per hour”.

6, again, hold down the Enter key after all the results appeared.

### excel in how to retain two decimal places

Excel is often used in the daily work of a program, there are times when people in the office, you may need to a particular piece of data accurate to three decimal places or two digits, or the need to remove all the digits after the decimal point, to retain the integer, then Excel should be how to set up to retain the decimal places? You can introduce two methods.

First of all, you should open the Excel form, if you want to remove the decimal point after the number of retained whole numbers, then the first thing you should do is to select the cell to be operated, and then right-click and then pop up the Options menu, select Set Cell Format, and then in the pop-up dialog box and then select the numerical value, you can set up a decimal number, according to the needs of the retained number of digits.

If you do not need a decimal point behind the number of digits only need to retain the whole number of words, then enter 0 after the number of decimal places, after the completion of the point and then click on the OK, this step is very critical, if the setup is completed after the completion of the point is not sure, then the setup will not play any role, which is why some people set up after the cell inside the number of important reasons for the cell is still not changed, you want to Setting success, remember that each step can not be ignored.

In fact, there is a simpler way, that is, they want to operate in the cell, and then directly select the menu bar shortcut keys to increase or decrease the number of decimal places, so that you can directly set the number of cells into the style they want.

Compared to Excel’s other operational settings in fact set the number of decimal places is relatively simple, and also relatively easy to learn.