Generating numbers in order with excel PLEASE HELP

[color1928]

I looked all over the place and can not find my answer
Here my project I have to create number string ab1000000 threw ab1500000
So in excel it was to look like this
Ab1000000
Ab1000001
Ab1000002
Ab1000003
And so on all the way until ab1500000
Can anyone help me

[MNTrevor]

Its actually quite simple. Enter the first two numbers into the columns they
go in...highlight both cells together...click and hold the little square in
the bottom corner of what you highlighted and drag it down until you reach
Ab1500000. By doing both cells you train the program to follow what you want
the format to look like.

"color1928" wrote:

>
> I looked all over the place and can not find my answer
> Here my project I have to create number string ab1000000 threw
> ab1500000
> So in excel it was to look like this
> Ab1000000
> Ab1000001
> Ab1000002
> Ab1000003
> And so on all the way until ab1500000
> Can anyone help me
>
>
> --
> color1928
> ------------------------------------------------------------------------
> color1928's Profile: http://www.excelforum.com/member.php...o&userid=25734
> View this thread: http://www.excelforum.com/showthread...hreadid=391448
>
>

[Henry]

Sorry, MN, but that won't work past Ab1065335 as there only 65536 rows in an
excel spreadsheet.

color1928, let us know where you want to put the strings and we'll try to
help.

Henry


"MNTrevor" <[email protected]> wrote in message
news:[email protected]...
> Its actually quite simple. Enter the first two numbers into the columns
> they
> go in...highlight both cells together...click and hold the little square
> in
> the bottom corner of what you highlighted and drag it down until you reach
> Ab1500000. By doing both cells you train the program to follow what you
> want
> the format to look like.
>
> "color1928" wrote:
>
>>
>> I looked all over the place and can not find my answer
>> Here my project I have to create number string ab1000000 threw
>> ab1500000
>> So in excel it was to look like this
>> Ab1000000
>> Ab1000001
>> Ab1000002
>> Ab1000003
>> And so on all the way until ab1500000
>> Can anyone help me
>>
>>
>> --
>> color1928
>> ------------------------------------------------------------------------
>> color1928's Profile:
>> http://www.excelforum.com/member.php...o&userid=25734
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=391448
>>
>>