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.

How to Remove the Leading Zero Before a Decimal in Excel By C. Taylor , Contributor Excel's design makes removing a decimal leading zero on business spreadsheets effortless.