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