Every numeric possibility with 8 Digits

[selant]

I want to create a list of every possibility of 8 digit numbers consisting of 0,1,2,3,4,5,6,7,8,9
There must have been 10^8 = 100,000,000 combinations if i am not wrong. Is it possible to create such list ?

 

[S8utt]

Can you do the following.

in cell a1 put 0
in cell a2 put =a1+1

drag this down untilyou get to 99999999

in cell1 put =text(a1,"00000000")

drag this formula down

you should have a list of 8 digits of all possible combinations.

On excel 2003 you will only have 65k rows so you'll have to split them up over multiple columns.

 

[selant]

Can you do the following.

in cell a1 put 0
in cell a2 put =a1+1

drag this down untilyou get to 99999999

in cell1 put =text(a1,"00000000")

drag this formula down

you should have a list of 8 digits of all possible combinations.

On excel 2003 you will only have 65k rows so you'll have to split them up over multiple columns.

Thank you for your help but it didnt work for me, may be i'm doing something mistaken but there should have been an easier way to get the combinations with a macro or something

 

[schielrn]

S8utt's method should work? Did you follow his directions exactly?

In A1 put:

=text(0,"00000000")

Then in A2 put:

=text(A1+1,"00000000")

Then copy that all the way down column A.

Again like they S8utt said it will also depend on what version of Excel you are using as far as how many columns you will need to list this out.

 

[selant]

I will try it again schielrn, i am using excel 2007. Thank you.

Edit : I used ";" instead of "," in the formula and it worked.. The maximum number of rows in my worksheet is 1048576. How can i exceed this limit ?

 

[schielrn]

You will not be able to exceed this limit. You will have to in column B, start your numbers where they ended off in column A, but you will need to do this for almost 100 columns?

May I ask what you are using or needing this list for? There may be a better way than listing everything out?

 

[selant]

I am trying to create a wordlist of each 8 number combinations to test my own wireless network security.

 

[schielrn]

So are you planning on looping through the entire wordlist? If so you can just incremement the number by one in the code if that is what you are trying to do?

for i = 0 to 99999999
'your code goes here
'maybe something like:
'format(i,"00000000")
next i

Hope that helps?

 

[selant]

I think the best is to use a wordlist generator, because its possibly gonna be very big in size like 762 megabytes or so.. Thanks anyway