When you use the RAND function on a Microsoft Excel spreadsheet ... The INT function will simply remove all the numbers after the decimal point, leaving you with just the integer.

By placing a zero before the decimal, the number is more readily recognized as less than one. By configuring a custom number format you can tell Excel to remove leading zeros. How to Stop Apps ...