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....