Bar code numbers to run in a sequential order

[dixiboy]

Good Day, I am trying to create a sequence of bar code number in Excel that I can drag down to run in sequential order. I would need the last digit to increase by one number as I drag it. I cannot seem to get it to work as it does not run in sequence. I converted the number to text because it reflected as

8.9E+19

<tbody>
</tbody>

below is the sequence i am trying to number. Any help would be appreciated.

89000000000002224578

89000000000002224579

89000000000002224580

89000000000002224581 thank you.

<colgroup><col></colgroup><tbody>
</tbody>

 

[dreid1011]

You're welcome. I was mucking around with mine because I knew it wasn't the greatest of solutions and I ended up with basically the same thing jtakw provided (because I didn't pay attention to what it was). If you end up needing even more numbers, but keeping to the 20 digit length, you can change the both instances of 15 in jtakw's formula to 18. Then you could have numbers up to 89999999999999999999.

 

[jtakw]

Thank you jtakw and dreid1011 for your replies to my post. Absolutely thrilled with the results and this will save me a couple of weeks worth of keying entries. Really indicates to me how little i know of Excel. Thank goodness for this site.

You're welcome, glad it worked for you.

You're welcome. I was mucking around with mine because I knew it wasn't the greatest of solutions and I ended up with basically the same thing jtakw provided (because I didn't pay attention to what it was). If you end up needing even more numbers, but keeping to the 20 digit length, you can change the both instances of 15 in jtakw's formula to 18. Then you could have numbers up to 89999999999999999999.

Actually, the formula will fail for anything over 15, because Excel can only do math up to 15 digits.

 

[dreid1011]

Oh yeah, that's true. And here I thought I had something Thanks for that. It would get messy then to make it work.