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.

If the ERROR.TYPE function in Excel not working for you, ensure the formula is correct, check for errors in the referenced cell, or repair Excel.