Stop random numbers from changing

[michael34223]

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

 

[VoG]

Select your numbers and copy them. Then Edit > Paste Special, tick Values and click OK.

 

[SteveO59L]

Are you doing this with code or formula?

 

[michael34223]

Select your numbers and copy them. Then Edit > Paste Special, tick Values and click OK.

Cool, I'll try that

Are you doing this with code or formula?

I am using a formula =RANDBETWEEN(0,36)


Thanks for the quick responses guys!

 

[michael34223]

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?