How to keep random number from changing using RANDBETWEEN?
 

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!!

Answer: How to keep random number from changing using RANDBETWEEN?
 

Preventing Recalculation of RANDBETWEEN Formula

The reason your random numbers keep changing is because the RANDBETWEEN formula recalculates every time there is a change in the sheet. To prevent this from happening, you can use a simple trick called "copy and paste as values". Here's how:

1. Select the cells containing the random numbers generated by
   Code:

   ---

   RANDBETWEEN

   ---

   .
2. Right-click and select "Copy" or use the keyboard shortcut "Ctrl+C".
3. Right-click again and select "Paste Special" or use the keyboard shortcut "Ctrl+Alt+V".
4. In the "Paste Special" dialog box, select "Values" and click "OK".

This will replace the formulas with their current values, effectively "locking in" the random numbers. Now, even if you make changes to the sheet or close and reopen it, the numbers will remain the same.

Try setting recalculation to manual "TOOLS/OPTIONS/CALCULATION/MANUAL"
(Assuming this is compatible with what you want to accomplish).
Stephen Powell

"TXlimogirl" wrote:

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!!

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!!

Stephen, you're a genius. It worked perfectly. THANK YOU!!!

"Stephen POWELL" wrote:

Try setting recalculation to manual "TOOLS/OPTIONS/CALCULATION/MANUAL"
(Assuming this is compatible with what you want to accomplish).
Stephen Powell

"TXlimogirl" wrote:

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!!

Copy and paste special as values in place once you are done

Regards,

Peo Sjoblom



"TXlimogirl" wrote:

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!!

Thanks a lot Stephen. : ) I changed the setting to "manual" and this resolved this issue of the changing values.