rolling 4 digit numbers for 4d?

[Shane Devenshire]

Hi,

1. Please put your questions in the body of the email, when we press Replay
in the Web interface we get

"An error occurred while sending your post
--------------------------------------------------------------------------------

We're sorry, but there was a problem with the system and your post was not
received. The error has been reported to Operations and will be investigated
as soon as possible. Please try again later."

2. what is your question?

 

[Pete_UK]

I think this is what you want:

=INT(6*RAND()+1)*1000+INT(6*RAND()+1)*100+INT(6*RAND()+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