sequential numbering of zero leading values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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....
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another Leading Zero Question 7
Need 7 digit number with differnt number of leading zeros 10
Concatenate Date and Number field for Append Query 0
Replacing cell numbers but leaving leading zero 1
How do I stop Excel from dropping leading zeros? 9
Leading Zero 11
Leading Zero as value not appearance 2
Add Leading Zeros 4

Back
Top