If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Generate series of numbers
Hey everybody!
I'm trying to build a small application that will basically generate a range of numbers for a specified beginning and end point. However, it also needs to "shorten" the numbers in assuming that if I wanted a range from 2000 to 2059, the result should be 200, 201, 202, 203, 204, and 205. Understanding that the results mean 200*, 201*, and so on. Conversly, if I put in 2000 to 2038, it will give me results like this: 200, 201, 202, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2037, 2038. Also, the to and from numbers are not limited to 4 digits... they can be as high 7 or 8 digits long. I really don't even know where to begin with this. Any help would be greatly appreciated! Thanks in advance, Dave |
#2
|
|||
|
|||
Generate series of numbers
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I generate Serial numbers in a table using Word | jws | General Discussion | 1 | September 15th, 2005 06:32 AM |
How to change a series of positive numbers to negative numbers | Ellie | Worksheet Functions | 5 | September 5th, 2005 05:10 PM |
Adding up Percentage calculated series of numbers???? | LD | Using Forms | 3 | January 8th, 2005 09:32 PM |
how to generate a random number between 2 numbers | rob | New Users | 5 | January 5th, 2005 01:57 PM |
How do I identify different numbers to a table of numbers | Erich Niemand | Worksheet Functions | 1 | September 9th, 2004 04:25 AM |