On Oct 22, 11:37*am, "T. Valko" wrote:
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.- Hide quoted text -

- Show quoted text -

The column that I am trying to add the random decimals to is filled
with data. The data ranges from 3.0 to 40.0 I want to add the
decimals to this column so that each number has one decimal palce,
from 0 to 9. ex: 3.2 or 40.7
The first suggested formula i was given filled the cell with #######.
The second suggested formula just made a Zero.
I am not fluent in excel so if there is a part of the formula that you
do not show because it is obvious to most, please show.
Thank-you for your help
JC