Hi,

I think that this is what you want, suppose your numbers are in the range
A1:A100 then

1. enter this formula in an empty column, say B1:

=RANDBETWEEN(1,9)*0.1

2. Copy this formula down to B100
3. Select all the formulas and choose Copy
4. Select the range A1:A100 and choose Edit, Paste Special and turn on
Values and turn on Add, then click OK.
5. Get rid of the formulas in column B

If this helps, please click the Yes button.

--
Thanks,
Shane Devenshire


" wrote:

I would like to add random decimals to one column in excel.
for example: 5.0 into 5.3, 10.0 into 10.1 and so on. Is this
possible?
Thank you for any info you may have.