Try

=INT((RAND()*50+1))

--
__________________________________
HTH

Bob

"Colin" wrote in message
...
I have a lottery worksheet to design which will produce 6 unique numbers
between 1 and 50 in six cells.
I use =INT(RAND()*51) at the moment which works well. How do I alter this
function so that 0 does not appear as one of the numbers?
--
Thank you,

Colin.