Microsoft Excel spreadsheet software offers users a large collection of tools for manipulating sets of numbers and text. The mathematical functions in Excel allow you to automate the process of erasing the decimal portion of a number and leaving just the whole number digits to the left of the decimal point. Once you know the right function to use, the procedure is straightforward.
- Skill level:
- Moderately Easy
Other People Are Reading
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.
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.
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.
Type another decimal number in cell A5.
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.
Use the integer function in an actual spreadsheet to drop the decimal values of a number and leave only the whole number.
Tips and warnings
- The integer function is available in Excel 2010 and earlier versions of the program.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for