How to keep numbers as integers in excel completely

In Excel, the number of decimal places kept as integers can be achieved by setting the number of decimal places of "Numeric" in the "Number" tab in "Format Cells" to "0".

Specific steps: 1. Select the cells or ranges that need to be modified, click the right-click pop-up menu, and left-click "Format Cells";

2. In the pop-up dialog box, the "Number" tab has been selected by default, just select "Number" in the left list;

3. Enter the number of decimal places you want in the input box after "Number of Decimal Places", if you want to take an integer.

Just enter "0", then click the "OK" button, back to **, the setting takes effect, and it is kept as an integer.

The results are presented:

You are really thoughtful, especially when making a salary system, if you want to take a whole number, you have to remove the number after the decimal point.

In excel, the number of decimal places set by the method of "cell format--numeric value--number of decimal places" is just not to show extra decimal places, in fact, the decimal still exists, and the electronic ** is still calculated according to the original number of decimal places.

For example, format all cells to 0 decimal places.

a1=a2=Cell display: a1=1

a2=2).

A3.

a1+a2, there is a situation of 1+2=4. （

4) after rounding).

To avoid similar problems with decimal points, the solutions are:

1. For all data involved in formula calculation, use the round function to round it as needed, such as the function "round(a2*b2,0)" is to keep the result of a2*b2 as an integer.

2. (office2003) Select "Options" in the menu bar of "Tools" -- "Automatic Recalculation" -- tick the checkbox of "Based on display accuracy". The required number of decimal places will be rounded off.

office

2007) Office Button Excel Options Advanced When calculating this workbook, select the corresponding workbook, and check "Set precision to displayed precision".

i.e.: if a1=

a2=cell display: a1=1

a2=2).

A3.

A1+A2, the value is 1+2=3.

Let's say the data is in column B.

Step 1. c1=round(b1,0)

Formula drop-down. Step 2.

Select column C, copy, paste in place, value. Are you sure.

Set the number of decimal places to 0, you can turn the value into an integer in Excel, the following steps take Excel 2007 as an example.

1. First of all, open the target ** file on the computer and enter the main interface.

3. Then in the shortcut menu at the beginning, click the "Reduce the number of decimal places" icon, then the decimal places will change from 3 digits to 2 digits.

4. Then click the "Reduce Decimal Places" icon again, and decrease the number of decimal places by one more place.

5. Click the "Reduce the number of decimal places" icon again, and the number of decimal places will be reduced to 0 digits.

6. After completing the above settings, you can turn the values into integers in Excel.

Ways to keep one decimal place:

1. The first method: set the cell formatting method.

Select the area, right-click - [Format Cells] - [Value] - [Two decimal places].

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

2. 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.

3. The third method: use the round function to keep two decimal places.

Select cell C2, enter the function: =round(A2,2), drop down to fill, and adjust the number of decimal places to go forward.

Features: The values have become the result of real rounding, and Brother Hui brings for example the contents of the C2 cell to participate in the operation, not the original. You can also copy the results and paste them into the original area to replace them.

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

Select cell C2 and enter the function: =text(A2,""dust return), pull down to fill.

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,"")。Numbers that are already rounded up when participating in the calculation.

5. The fifth method: use the clipboard or notepad method to become a true 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, select [Clipboard] to paste.

6. The sixth method: the display accuracy is the standard method to become a real rounded number.

After formatting the cells according to the first or second method, click [Office Button] - [Excel Options] - [Advanced] - [When Computing This Workbook] - select [Set Precision to Displayed Precision], and click the [OK] button after completing the setting.

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.

1. First of all, open the target form file on your computer and enter the main interface.

3. Then click the "Reduce Decimal Places" icon at the beginning of the shortcut menu, and the number of decimal places will change from 3 to 2.

4. Click the "Decrease Decimal Number" icon again, and the decimal number will be reduced by another digit.

5. Click the "Reduce Decimal Number" icon again to reduce the decimal number to 0 digits.

6. After the above settings are completed, the value can be changed to an integer in Excel.

1. First of all, open Excel** in the computer, and you can see the numbers that need to be adjusted to integers, as shown in the figure below.

2. Click on the title bar"Formula"button, select the "Mathematics & Trigonometry" option, as shown in the image below.

3. Then in the drop-down menu that appears, select the "int" function, as shown in the image below.

4. At this time, the function ** will pop up, and you need to enter the formula to round it, as shown in the figure below.

5. Then click the cell you need to round up, enter it into the formula, and click the OK button, as shown in the figure below.

6. Finally, you can see that the numbers are directly discarded after the decimal point Spring Chaos and will not be rounded, as shown in the figure below, which is required to be completed.

Method 1: Round up with a formula:

Let's say the data is written in cell A1, 1Round the data to the nearest integer.

round(a1,0)

2.The decimal part of the number is truncated and an integer is returned.

trunc(a1)

3.Rounds down the number to the nearest whole number.

int(a1)

4.Rounds the data to the specified number of digits.

rounddown(a1,0)

5.Round up the data by the specified number of digits to the decimal place = roundup(a1,0) after the specified number of digits

6.Round up the data to an integer multiple of 1.

ceiling(a1,1)

7.Round down the data to an integer multiple of 1.

floor(a1,1)

Method 2 is implemented in the original cell:

Select the cell where the data is located, right-click, set the cell format, custom, write 0 in the type, (or set the cell format to numeric format, set the number of decimal places to 0), OK.

The rounding function is round

Usage: =round(numeric, 0).

It can be applied outside of the original calculation formula: =round(calculation formula, 0).

=round(a1,0): Reserved to an integer.

round(a1,2): retains 2 decimal places.

round(a1,1): retains 1 decimal place.

round(a1,-1): Reserved to the tenth digit.

round(a1,-2): Reserved to the hundredth place.

You can use functions such as round, int and so on to round up according to different requirements. Specifically, you can talk about the requirements and simulate the raw data and results.