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.

This tutorial will show you how to change the number of Decimal places in Microsoft Excel using any one of these 3 methods.

Learn how to automatically insert decimal points in Excel spreadsheets using Excel Options, Registry Editor orl Group Policy Editor.

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.