If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add column to file with numbers
Hi,
I am manipulating data from one db to another and have found that I need to have the ID numbers 1 to 6000 in the left side 1st column. How do I get these numbers in without having to do them 1 x 1. Thanks Excel 2002. |
#2
|
|||
|
|||
Add column to file with numbers
Rock,
1) Insert a new column A, then in cell A1, enter =ROW() Copy cell A1, press Ctrl-End, then Home, then Shift-Ctrl-Home, then Enter. Select column A, then paste special Values, and you're done. 2) If column A is entirely filled (no blanks), then you could insert a new column A, type 1 in A1, 2 in A2, select both A1 and A2, then double-click the fill handle. 3) You could also use a macro HTH, Bernie MS Excel MVP "rock" wrote in message ... Hi, I am manipulating data from one db to another and have found that I need to have the ID numbers 1 to 6000 in the left side 1st column. How do I get these numbers in without having to do them 1 x 1. Thanks Excel 2002. |
#3
|
|||
|
|||
Add column to file with numbers
Many thanks Bernie,
Did the 1st suggestion and it was fine. I now need to take the column row down 1 cell so it matches the rest of the data. eg A B C D E F 1 User_ID Forename Surname Addr1 Addr 2 Addr3 2 1 admin admin 3 2 John Lee PO Box 3362 I need to place the 1 in A column where the 1 is now in Col B I tried to insert a row at the top of A so it I could type the title then delete col B, but it didn't work as I needed it. Also.. I need to change the date format.. First 2 rows are as I need, the rest is how 6000 are in col 0 20090820 20090820 60223 60324 60329 60416 60418 60426 60428 60503 60506 60506 Many thanks, rock Bernie Deitrick wrote: Rock, 1) Insert a new column A, then in cell A1, enter =ROW() Copy cell A1, press Ctrl-End, then Home, then Shift-Ctrl-Home, then Enter. Select column A, then paste special Values, and you're done. 2) If column A is entirely filled (no blanks), then you could insert a new column A, type 1 in A1, 2 in A2, select both A1 and A2, then double-click the fill handle. 3) You could also use a macro HTH, Bernie MS Excel MVP "rock" wrote in message ... Hi, I am manipulating data from one db to another and have found that I need to have the ID numbers 1 to 6000 in the left side 1st column. How do I get these numbers in without having to do them 1 x 1. Thanks Excel 2002. |
#4
|
|||
|
|||
Add column to file with numbers
I have found the way to add the 200 before the numbers okay, but still
need to be able to move a column of numbers down 1 cell. Thanks rock rock wrote: Many thanks Bernie, Did the 1st suggestion and it was fine. I now need to take the column row down 1 cell so it matches the rest of the data. eg A B C D E F 1 User_ID Forename Surname Addr1 Addr 2 Addr3 2 1 admin admin 3 2 John Lee PO Box 3362 I need to place the 1 in A column where the 1 is now in Col B I tried to insert a row at the top of A so it I could type the title then delete col B, but it didn't work as I needed it. Also.. I need to change the date format.. First 2 rows are as I need, the rest is how 6000 are in col 0 20090820 20090820 60223 60324 60329 60416 60418 60426 60428 60503 60506 60506 Many thanks, rock Bernie Deitrick wrote: Rock, 1) Insert a new column A, then in cell A1, enter =ROW() Copy cell A1, press Ctrl-End, then Home, then Shift-Ctrl-Home, then Enter. Select column A, then paste special Values, and you're done. 2) If column A is entirely filled (no blanks), then you could insert a new column A, type 1 in A1, 2 in A2, select both A1 and A2, then double-click the fill handle. 3) You could also use a macro HTH, Bernie MS Excel MVP "rock" wrote in message ... Hi, I am manipulating data from one db to another and have found that I need to have the ID numbers 1 to 6000 in the left side 1st column. How do I get these numbers in without having to do them 1 x 1. Thanks Excel 2002. |
#5
|
|||
|
|||
Add column to file with numbers
Did it this way..
Deleted the top A row and put the other cols up 1 cell so they were all equal. The added a row and pasted the titles in the top row. Maybe not the best way, but it worked. rock rock wrote: I have found the way to add the 200 before the numbers okay, but still need to be able to move a column of numbers down 1 cell. Thanks rock rock wrote: Many thanks Bernie, Did the 1st suggestion and it was fine. I now need to take the column row down 1 cell so it matches the rest of the data. eg A B C D E F 1 User_ID Forename Surname Addr1 Addr 2 Addr3 2 1 admin admin 3 2 John Lee PO Box 3362 I need to place the 1 in A column where the 1 is now in Col B I tried to insert a row at the top of A so it I could type the title then delete col B, but it didn't work as I needed it. Also.. I need to change the date format.. First 2 rows are as I need, the rest is how 6000 are in col 0 20090820 20090820 60223 60324 60329 60416 60418 60426 60428 60503 60506 60506 Many thanks, rock Bernie Deitrick wrote: Rock, 1) Insert a new column A, then in cell A1, enter =ROW() Copy cell A1, press Ctrl-End, then Home, then Shift-Ctrl-Home, then Enter. Select column A, then paste special Values, and you're done. 2) If column A is entirely filled (no blanks), then you could insert a new column A, type 1 in A1, 2 in A2, select both A1 and A2, then double-click the fill handle. 3) You could also use a macro HTH, Bernie MS Excel MVP "rock" wrote in message ... Hi, I am manipulating data from one db to another and have found that I need to have the ID numbers 1 to 6000 in the left side 1st column. How do I get these numbers in without having to do them 1 x 1. Thanks Excel 2002. |
Thread Tools | |
Display Modes | |
|
|