How do I generate a list of 5-digit numbers in Excel?
 

I need to create a list of 1000 numbers of 5 digits. The numbers can't be
repeated.

How do I generate a list of 5-digit numbers in Excel?
 

The numbers themselves can't be repeated, or individual digits in each
number must be unique?

if the former then this would work...

for x=10000 to 10999
debug.print x
next x

--
Tim Williams
Palo Alto, CA


"Cowboy" wrote in message
...
I need to create a list of 1000 numbers of 5 digits. The numbers can't be
repeated.

How do I generate a list of 5-digit numbers in Excel?
 

Are leading zeros OK. Example, is 00001 a five digit number?

--
Regards,
Tom Ogilvy

"Cowboy" wrote in message
...
I need to create a list of 1000 numbers of 5 digits. The numbers can't be
repeated.

How do I generate a list of 5-digit numbers in Excel?
 

take a look at

http://www.mcgimpsey.com/excel/udfs/randint.html


In article ,
Cowboy wrote:

I need to create a list of 1000 numbers of 5 digits. The numbers can't be
repeated.

How do I generate a list of 5-digit numbers in Excel?
 

Nope. Any number from 10000 to 99999. Can you help me, please?

"Tom Ogilvy" wrote:

Are leading zeros OK. Example, is 00001 a five digit number?

--
Regards,
Tom Ogilvy

"Cowboy" wrote in message
...
I need to create a list of 1000 numbers of 5 digits. The numbers can't be
repeated.

How do I generate a list of 5-digit numbers in Excel?
 

you help me, please?

See JE's answer.

--
Regards,
Tom Ogilvy

"Cowboy" wrote in message
...
Nope. Any number from 10000 to 99999. Can you help me, please?

"Tom Ogilvy" wrote:

Are leading zeros OK. Example, is 00001 a five digit number?

--
Regards,
Tom Ogilvy

"Cowboy" wrote in message
...
I need to create a list of 1000 numbers of 5 digits. The numbers can't
be
repeated.