Random Number Without Regeneration

[massnative]

Hi all,

I know how to create a random number between a set of numbers (i.e. =randbetween(1,99999), however, I cannot find a way to have the number "freeze", or hold from regeneration, when I re-open the spreadsheet, press F9, or decide to add another row for a new number to generate. Any ideas on how to have it generate the random number and then "turn itself off"?

Also, ideas on how to make the =randbetween formula equal a set amount of digits (i.e. 5 digits long)?

Thank you!

 

[shg]

find a way to have the number "freeze", or hold from regeneration

Copy the results of the formula and paste as values.

how to make the =randbetween formula equal a set amount of digits (i.e. 5 digits long)?

=RANDBETWEEN(10000,99999)

 

[T. Valko]

Hi all,

I know how to create a random number between a set of numbers (i.e. =randbetween(1,99999), however, I cannot find a way to have the number "freeze", or hold from regeneration, when I re-open the spreadsheet, press F9, or decide to add another row for a new number to generate. Any ideas on how to have it generate the random number and then "turn itself off"?

Also, ideas on how to make the =randbetween formula equal a set amount of digits (i.e. 5 digits long)?

Thank you!

See this...

http://mcgimpsey.com/excel/udfs/randint.html