=Rand() Help

[Steve Klenner]

How can I create a formula that will allow me to generate a random 6 digit
number?

Thanks

 

[Dan E]

=ROUND(RAND()*1000000,0)

Dan E