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

The DEC2BIN function in Microsoft Excel is an Engineering function, and its purpose is to convert a decimal number to binary. The formula for the DEC2BIN is DEC2BIN( Number, [Places]).

When you use the RAND function on a Microsoft Excel spreadsheet, by default the random number will be nine or ten digits long, extending well past the decimal point. The RAND function does not ...

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.