Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
TXlimogirl
 
Posts: n/a
Default 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!!
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Stephen POWELL
 
Posts: n/a
Default

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

  #4   Report Post  
Frank Kabel
 
Posts: n/a
Default

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


  #5   Report Post  
TXlimogirl
 
Posts: n/a
Default

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



  #6   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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

  #7   Report Post  
Junior Member
 
Posts: 1
Default

Quote:
Originally Posted by Stephen POWELL View Post
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!!
Thanks a lot Stephen. : ) I changed the setting to "manual" and this resolved this issue of the changing values.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
How can I get Positive values only from the random number generat. Markw3700 Excel Discussion (Misc queries) 1 January 21st 05 01:37 AM
Running Total of Random Number Mr H Excel Discussion (Misc queries) 4 January 19th 05 11:35 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM
Changing number in same cell jrwheels Excel Worksheet Functions 2 October 28th 04 01:58 PM


All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"