View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default rolling 4 digit numbers for 4d?

I think this is what you want:

=INT(6*RAND()+1)*1000+INT(6*RAND()+1)*100+INT(6*RA ND()+1)*10+INT(6*RAND
()+1)

In future, use the message body to explain what you want, rather than
try to cram it into the header.

Hope this helps.

Pete

On Jan 8, 6:43*am, Curious wrote: