Stop random numbers from changing

michael34223

New Member
Joined
May 3, 2011
Messages
3
I am trying to create a basic roulette simulation for an assignment, with 5-10000 runs. However, once I have gotten my random numbers, I need then to stop changing. I used the =RANDBETWEEN(0,36), but it changes whenever I change any other cell.

Thanks for your help
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

VoG

Legend
Joined
Jun 19, 2002
Messages
63,651
Select your numbers and copy them. Then Edit > Paste Special, tick Values and click OK.
 

michael34223

New Member
Joined
May 3, 2011
Messages
3
Select your numbers and copy them. Then Edit > Paste Special, tick Values and click OK.
I just tried this, and it worked. Thanks for the seemingly very obvious, but also easy to overlook (for me at least) solution! Is there somewhere here to leave good feedback for helpful people?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,797
Messages
5,470,833
Members
406,728
Latest member
BCM7

This Week's Hot Topics

Top