Hi,

Probably the easiest way is to list your numbers 0-9 in one column and alongside each of them in another column put the formula:

=RANDBETWEEN(0,9)
Now just sort the two columns using the random number as the key.

You could achieve the same sort of thing with a macro if you didn't want to see the 'workings'

HTH