One way

put 1 and A1 2 in A2 and so on down to 49 in A49 in B1, put =RAND()
copy down the formula to B49, select both column and do datasort and sort
ascending
by column B, now select the 7 first numbers.

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Antonio" wrote in message
...
hi all

is it possible to get excel to wheel all lotto numbers (1 to 49)
and save them to excel??

tks
António