How to make random numbers stay the same
Thank you. This answered the question. I put it to use and it worked.
Thanks alot.!!
wyobuff
"Mike H" wrote:
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?
|