Are these in a single column range--like A1:A496?

If yes, then put:
=rand()
in B1 and drag down to B496

Then select A1:B496 and sort by column B.

Stuart Leeman wrote:

I have a set of 496 numbers, from 1 to 496 that I have to randomize. Any
idea how to easliy do it?
Thanks

--

Dave Peterson