Say your list of names was in A1 to A100.

Enter this formula in B1:

=INT(RAND()*(99999+1-10000)+10000)

And copy down to B100.

Then, you can turn *off* auto calc by:

<Tools <Options <Calculation tab,
And click on "Manual"

Now, every time you hit <F9, you'll get a new set of random numbers next to
your list of names.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Empress" wrote in message
...
I need to have numbers randomly assinged to names. The numbers will all
be 5
digits. I was told that excel can do this but I can't seem to figure it
out.

Please help!!!