You want a random shuffle of the digits 0 - 9

in A1:I1 put in the digits 0 to 9
in A2:I2 put in the formula
=rand()

select A1:I2 and do Data=Sort, select options and left to right

then select row2 as the key. (ascending or descending - your choice)

This will sort your numbers. Also, the random numbers in column 2 will be
regenerated so you are ready to repeat the sort for a new random
organization.

--
Regards,
Tom Ogilvy

"Pete" wrote in message
...
I want to randomly pick a number between 1000000000 and 9999999999 with a
couple of options to contend with.

First: I don't ever want to pick the 1234567890 and 9876543210.
Second: if the number generated has any repeat numbers then I want to
regect
it and select another one. IE # 1123421456 would be rejected because of
the
repeatitive 1's.
Third: After the number is set with no repeat numbers I want to seperate
it
into their own colums for frther minipulation.

And ideas.
Thanks for you help.
--
Pete