Please help with detailed serial numbers

[EtienneP]

Hi there,

I have a range of serial numbers (from number xxx to number xxx) and they account 100 numbers. How do I get these 100 numbers to show in a column?

I have from Serial number 894270210912500325 to Serial number 894270210912500424 (100 numbers) and I need to show them individually in one column, like so:
894270210912500325
894270210912500326
894270210912500327
894270210912500328
etc.
etc.
until
894270210912500424

Is this even possible in Excel?

Thanks!!

[Special-K]

You say you want them in one column
But you dont describe how they are otherwise set up

Post your workbook so we can see how they are now

[Richard Buttrey]

Hi,

Enter the first 'number' string in A1 as text. Then in A2 and copied down enter
=LEFT(A1,15)&TEXT(VALUE(RIGHT(A1,3)+1),0)

Regards

[EtienneP]

Hi,

Thanks, please see the sheet attached.

You will see that there are a total of 1400 numbers, issued in batches. I need to have the 1400 serial numbers on their own.

I tried converting them to number format, but it changes the last few digits into zero's. I have no idea why it does this either?

[martindwilson]

like this maybe

[EtienneP]

Yup, that looks like it, Thanks!

Can you tell me why excel changes the last digits to zero's? Is it a setting/format issue somewhere?