How to Drop Decimal Places Without Rounding in Microsoft Excel

1. Open a blank worksheet in Excel and type a decimal number in the A1 cell. Use this worksheet for practice before applying the procedure to an actual file.
2. Type the 'integer function' into cell B1 as follows: f=INT(A1). The integer function lops off the decimal value of a number leaving only the whole number digits to the left of the decimal place. The formula in cell B1 instructs Excel to find the integer value of cell A1 and place that value in cell B1.
3. Click any other cell in the spreadsheet to exit from cell B1. The cell will now display the integer value of the number in A1. For example, if A1 contains the number 10.54, cell B1 will display the number 10.
4. Type another decimal number in cell A5.
5. Copy cell B1 and paste it into cell B5 to put a copy of the integer formula in B5. Click out of the cell to show the integer value of A5 in B5. As you copy and paste the integer formula, Excel automatically adjusts the parameters to find the integer value of A5 rather than A1.
6. Use the integer function in an actual spreadsheet to drop the decimal values of a number and leave only the whole number.