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:
- Select the cells containing the random numbers generated by .
- Right-click and select "Copy" or use the keyboard shortcut "Ctrl+C".
- Right-click again and select "Paste Special" or use the keyboard shortcut "Ctrl+Alt+V".
- 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.