Create sort number of 6 digit...

[DavidRoger]

Hi all,

I have been sorting the number 123456 to get a list of number. The numbers 123456 have sub-number each and are limited from 01 - 58. And there are not repetition among the sub-number.

Example: The first number shall be view as 10203040506, second is 10203040507,...

I have found a way to do it but I am not sure if I have done everything correctly because the process is long.

I want to counter check my list if you have a better solution.

 

[mikerickson]

No, I'm not a genius until the OP says I am.


P.S. In my opinion the best way to predict lottery numbers is to use the RAND function.

 

[DavidRoger]

Are you looking to list all of those possibilites?

Quite true what you said.

I am looking to build the list not the possibilities.

We all know that is quite impossible. There are random numbers.

Do you know how can I actually build the list so I can counter check my list?