From Excel's help file for the RAND() function (https://support.microsoft.com/en-us/...0-021ea9f5be73 ):
To generate a random real number between a and b, use:
=RAND()*(b-a)+a
. Nest that inside of a ROUND() function to round to the desired number of decimal places, or use number formatting to display to the desired number of decimal places (depending on exactly what you need the cell's value to be).