How to use the INT Function in Excel. In this tutorial, we are going to turn the decimal inside the table into integers. Click the cell where you want to see the result, then type =INT(A2).

If you are just looking to get rid of the numbers after the decimal point, using the INT function with your RAND function should do the trick. Open a new Microsoft Excel 2010 spreadsheet.

Inserting the Next Consecutive Integer in Excel. Creating a list of consecutive numbers is one of the easiest ways to create unique IDs for product lists, transaction IDs or event numbers.