| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to generate 3 digit numbers out of 0 to 9 number | Excel Discussion (Misc queries) | |||
| Want to sort a list of numbers by last two digit... | Excel Discussion (Misc queries) | |||
| List Sorts Numbers By First Digit, Rather Than The Whole Number. | Excel Discussion (Misc queries) | |||
| How to generate a list of randomly selected numbers within a range | Excel Worksheet Functions | |||
| I wish to change the last digit in a list of random numbers. To a. | Excel Worksheet Functions | |||
Hybrid Mode
