We should point out that the ability to determine the number of decimal places shown on a spreadsheet is possible on all versions of Excel from the year 2007 to date.

Enter the decimal measurement in cell A1 of Microsoft Excel. As an example, enter "5.792" in cell A1. Enter "=RoundDown(A1,0)" in cell B1 to extract the number of feet.

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.