Do you already have 5.0 and 10.0 entered in some cells?

If so, here's one way...

Enter this formula in some cell, assume X1:

=ROUND(RAND(),1)

Assume the numbers you want to change are in the range A1:A5

Select cell X1
Goto EditCopy
Select the range A1:A5
Goto EditPaste SpecialAddOK
With A1:A5 still selected
Goto EditCopy
Then EditPaste SpecialValuesOK

Delete cell X1

--
Biff
Microsoft Excel MVP


wrote in message
...
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.