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 ...

1] Remove both the Decimal and Thousand separators In most European countries, the Dot (.) characterizes a thousand separators, while the Comma is all about the decimal point.