permutations of six digit number
 

Hi,

I'm hoping someone could help me.

I need to generate all of the permutations of a six digit number using 0-9
where every number can be repeated and in any order. Is there any way to do
that in Excel or Access?

Thanks

permutations of six digit number
 

that is a million numbers.
do you really need all million at once or just a random selection from them.

one way to generate them is
select all the cells format-gell-number-custom 000000
in Cell A1
enter 0
in A2 enter =A1+1

select A2
copy
select A2:A50000
paste
Select B1
enter=A1+50000
copy
select B1:T50000
paste
Select A1:T50000
copy and paste special values

now what do you want to do with them?

"steed800" wrote:

Hi,

I'm hoping someone could help me.

I need to generate all of the permutations of a six digit number using 0-9
where every number can be repeated and in any order. Is there any way to do
that in Excel or Access?

Thanks

permutations of six digit number
 

Dont need anthing but this, there will be 1 million permutations from
000000 to 999999.

steed800 wrote:

Hi,

I'm hoping someone could help me.

I need to generate all of the permutations of a six digit number using 0-9
where every number can be repeated and in any order. Is there any way to do
that in Excel or Access?

Thanks

permutations of six digit number
 

thanks! that worked great.

i didn't realize that was a million numbers so i'll have to just use a sample.

"bj" wrote:

that is a million numbers.
do you really need all million at once or just a random selection from them.

one way to generate them is
select all the cells format-gell-number-custom 000000
in Cell A1
enter 0
in A2 enter =A1+1

select A2
copy
select A2:A50000
paste
Select B1
enter=A1+50000
copy
select B1:T50000
paste
Select A1:T50000
copy and paste special values

now what do you want to do with them?

"steed800" wrote:

Hi,

I'm hoping someone could help me.

I need to generate all of the permutations of a six digit number using 0-9
where every number can be repeated and in any order. Is there any way to do
that in Excel or Access?

Thanks

permutations of six digit number
 

one possibility for a sample is randbetween(0,999999)
each time it is calculated a new one will be generated
I would copy it about 10 times cause a calc, copy and paste special values
somewhere else.
you may have duplicate numbers:


"steed800" wrote:

thanks! that worked great.

i didn't realize that was a million numbers so i'll have to just use a sample.

"bj" wrote:

that is a million numbers.
do you really need all million at once or just a random selection from them.

one way to generate them is
select all the cells format-gell-number-custom 000000
in Cell A1
enter 0
in A2 enter =A1+1

select A2
copy
select A2:A50000
paste
Select B1
enter=A1+50000
copy
select B1:T50000
paste
Select A1:T50000
copy and paste special values

now what do you want to do with them?

"steed800" wrote:

Hi,

I'm hoping someone could help me.

I need to generate all of the permutations of a six digit number using 0-9
where every number can be repeated and in any order. Is there any way to do
that in Excel or Access?

Thanks