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.

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" <Cowboy@discussions.microsoft.com> wrote in message
news:40937F0A-BCDC-4BC9-8B12-F606CE600B58@microsoft.com...
> I need to create a list of 1000 numbers of 5 digits. The numbers can't be
> repeated.

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

--
Regards,
Tom Ogilvy

"Cowboy" <Cowboy@discussions.microsoft.com> wrote in message
news:40937F0A-BCDC-4BC9-8B12-F606CE600B58@microsoft.com...
> I need to create a list of 1000 numbers of 5 digits. The numbers can't be
> repeated.

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" <Cowboy@discussions.microsoft.com> wrote in message
> news:40937F0A-BCDC-4BC9-8B12-F606CE600B58@microsoft.com...
> > I need to create a list of 1000 numbers of 5 digits. The numbers can't be
> > repeated.
>
>
>

> you help me, please?

See JE's answer.

--
Regards,
Tom Ogilvy

"Cowboy" <Cowboy@discussions.microsoft.com> wrote in message
news:EE68198D-B2AF-4FEE-BDB8-DCD3388B3701@microsoft.com...
> 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" <Cowboy@discussions.microsoft.com> wrote in message
> > news:40937F0A-BCDC-4BC9-8B12-F606CE600B58@microsoft.com...
> > > I need to create a list of 1000 numbers of 5 digits. The numbers can't
be
> > > repeated.
> >
> >
> >

take a look at

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


In article <40937F0A-BCDC-4BC9-8B12-F606CE600B58@microsoft.com>,
Cowboy <Cowboy@discussions.microsoft.com> wrote:

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