Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
In Excel, I want to have all telephone numbers display in the sam. | Excel Worksheet Functions | |||
Columns in Excel are numbers instead of letters, how do I change . | Excel Discussion (Misc queries) | |||
how do i set up to auto detect duplicated numbers in an excel fiel | Excel Discussion (Misc queries) | |||
sort numbers in EXCEL? | Excel Worksheet Functions |