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

Warnings Excel will only produce binary numbers with up to 10 bits. This means that it can only convert decimal numbers greater than -513 and less than 512.

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

This just tells Excel, in addition to the colors, make the numbers percentages with no decimals. If you want one decimal place, just add it to the number, e.g., 0.0%.