in the adjacent column to your numbers put in the formula

=rand()

then drag fill down

Now sort both columns with this column with the formula as the key formula.
This will randomize your numbers.

--
Regards,
Tom Ogilvy

"justaguyfromky" wrote in message
...
I have a spreadsheet that has a column with 10 cells. Each cell will have
its own number in it, but I want them to be randomly generated from 0-9.
I
need all cells to have a unique number in it. any help with this would be
appreciated. Thanks