Random Number Generation Question

S

Steve Klenner

I'm using the formula =randbetween(100000,999999)

Unfortunately it constantly re-generates a new number with any change to
worksheet.

Is there a way to allow the worksheet to generate the random number and not
change it?

Thanks
Steve
 
A

Anon

Steve Klenner said:
I'm using the formula =randbetween(100000,999999)

Unfortunately it constantly re-generates a new number with any change to
worksheet.

Is there a way to allow the worksheet to generate the random number and not
change it?

Thanks
Steve
Click to expand...

Copy the cell and then Paste Values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Password Generation 0
How to save random numbers? 3
RANDBETWEEN generating numbers outside range 5
RANDBETWEEN() 9
How can I use the same random number twice in the same formula? 2
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1
eliminate negative value from normal random number distribution 4
random number generator 7

Top