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" <1940.RemoveThis@pobox.com> wrote in message news:eKyq58YIKHA.3928@TK2MSFTNGP04.phx.gbl...
>> 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" <1940.TakeThisOut@pobox.com> wrote in message
>> news:eKyq58YIKHA.3928@TK2MSFTNGP04.phx.gbl...
>>> 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" <1940.RemoveThis@pobox.com> wrote in message
>>> news:eKyq58YIKHA.3928@TK2MSFTNGP04.phx.gbl...
>>>> 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.
>>>
>>>