Hi,
I'm using the random number generator in excel and want it to calculate only once. The goal is to generate a list of 8 numbers one time using 8 instances of that function, and then to disable the function from re-calculating.
I want to be able to preserve both the function in the cell and the initial list of numbers that is generated. (Currently nothing prevents the formula from re-calculating.)
Anyone know if this is possible??
Thanks!
Liz
I'm using the random number generator in excel and want it to calculate only once. The goal is to generate a list of 8 numbers one time using 8 instances of that function, and then to disable the function from re-calculating.
I want to be able to preserve both the function in the cell and the initial list of numbers that is generated. (Currently nothing prevents the formula from re-calculating.)
Anyone know if this is possible??
Thanks!
Liz