Hi
you could use 'Edit - Paste Special - Value' to remove the formula.

--
Regards
Frank Kabel
Frankfurt, Germany

"TXlimogirl" schrieb im
Newsbeitrag ...
I am trying to generate a set list of random numbers between 1 and 42
using
the RANDBETWEEN formula. The problem is everytime I click another
cell
anywhere in the sheet or even open and close the sheet after saving
it, the
random numbers change again. How can I keep the random numbers from
changing?
Any help would be greatly appreciated! Thank you!!