If you *don't* have the ATP installed, you can use this formula:

=INT(RAND()*90000+10000)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Elkar" wrote in message
...
First off, you'll need the "Analysis TookPak" Add-In installed. To do
this,
click TOOLS, then ADD-INS, then check the box next to "Analysis TookPak".

Then you can use the following formula:

=RANDBETWEEN(10000,99999)

HTH,
Elkar


"scotjo" wrote:


Hello...Hopefully somebody can help, because I no longer remember how to
do this. I am trying to populate a random number list. I need 137
different random numbers , with the numbers between 10000 and 99999.
If anyone knows how to do this, you are my hero.


Thanks!


--
scotjo
------------------------------------------------------------------------
scotjo's Profile:
http://www.excelforum.com/member.php...o&userid=30206
View this thread:
http://www.excelforum.com/showthread...hreadid=498872