| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
sequential numbering of zero leading values
I have a value with leading zeros that is 18 digits, for example
001001001001001001. How do I create a list of sequential numbers for this value for example: 001001001001001001 001001001001001002 001001001001001003 etc.... etc.... |
|
#2
|
|||
|
|||
|
If your first number is in cell A1 (which you have to enter as text as excel
does not recognise numbers more than 15 characters) Then copy the following formula in A2, and drag down: =LEFT(A1,LEN(A1)-4)&INT(RIGHT(A1,4))+1 Mangesh "nagorb" wrote in message ... I have a value with leading zeros that is 18 digits, for example 001001001001001001. How do I create a list of sequential numbers for this value for example: 001001001001001001 001001001001001002 001001001001001003 etc.... etc.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sequential numbering in non adjacent cells | Excel Worksheet Functions | |||
| Sequential numbering | Excel Discussion (Misc queries) | |||
| automatic sequential numbering in excel or word | Excel Discussion (Misc queries) | |||
| Leading Zeros in Numeric Values | Excel Worksheet Functions | |||
| How do I set up sequential numbering on labels | Excel Worksheet Functions | |||
Hybrid Mode
