How to make random numbers stay the same
I would say the easiest is to copy the cells, then paste special/values to
get rid of the formula.
Or, if this is the only calculation in the workbook and you feel the desire,
you can go to Tools - Options - Calculation tab and change to manual, but I
wouldn't suggest that unless you can remember to change it back when
necessary.
"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?
|