Press your F9 function key continually and watch Col B!!

"Antonio" wrote in message
...
Hi
Your reply, this gives me random combinations, done
manualy, and not an automatic number generator.
Tks n rgds
António


"Peo Sjoblom" wrote:

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