|
Generating numbers in order with excel PLEASE HELP
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 |
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 |
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" wrote in message ... 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 |
| All times are GMT +1. The time now is 12:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com