Hi,

You can use a macro but another way is to generate the random numbers and
copy them. paste them to a new location using

PasteSpecial|Values

Mike

"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?