View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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.