Kind of late, but for the record.

Here is how I generated 9 random numbers from 0 to 0.1
=RAND()*0.1
This filled a cell with a random number.
Then I filled the column using the + in the lower right corner of the cell
dragging down.
I had 9 random numbers.

RANDBETWEEN(-1,1) gives positive and negative random numbers.



"cawhitaker" wrote:

I want to generate 45 random numbers between the numbers 1 and 300. I have
tried using RAND, RND, and a couple others. I can get it to generate one
random number, but I want to generate more than one random number (45).
Please help.