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.

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.

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.

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.

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.