Hi,

There is another simple way, if you have the Analysis ToolPak add-in attached:

Choose Tools, Data Analysis, Random Number Generation, enter 1 in the Number
of Variables, enter the number of numbers you want in Number of Random
Numbers, choose Uniform under Distribution, click Output Range and indicate
the top cell of the range you want to fill.

--
Thanks,
Shane Devenshire


"wyobuff" wrote:

I am making a sample inspection database and I want to assign random numbers
to a series of cells. When I make a change or open the spreadsheet, the
numbers all change to a new random number. How can I use the formula but
make it keep the random numbers that it chooses?