Replacing A Column Of Numbers

[Bob]

Hello,

New user of Excel 2007, and Excel in general.
Should be simple, but I just can't figure out how.

Have a column of numbers in Column A
In Column B (row 1)I have the formula of what's in A (row 1) multiplied
by 1000

And I have dragged this formula downwards, so I now have in each row B
what is in the same row in Column A multiplied by 1000.

So far, all is fine.

Now, I want to replace what's in Column A by the newly generated values
in Column B (row by row replacement)

I can't just Cut out everything in Column A, as B then disappears, as,
I've finally figured out, Column B values depends on Column A values.

How do I move everything I've generated in Column B to Replace what's in
Column A ?

Much thanks,
Bob

 

[Gordon]

Hello,

New user of Excel 2007, and Excel in general.
Should be simple, but I just can't figure out how.

Have a column of numbers in Column A
In Column B (row 1)I have the formula of what's in A (row 1) multiplied
by 1000

And I have dragged this formula downwards, so I now have in each row B
what is in the same row in Column A multiplied by 1000.

So far, all is fine.

Now, I want to replace what's in Column A by the newly generated values
in Column B (row by row replacement)

I can't just Cut out everything in Column A, as B then disappears, as,
I've finally figured out, Column B values depends on Column A values.

How do I move everything I've generated in Column B to Replace what's in
Column A ?

Much thanks,
Bob

Highlight Column B, right-click and choose Copy.
Highlight Column A, right-click, choose "Paste Special" and choose Values.

HTH

 

[Gord Dibben]

Copy column B.

Select A1 and Edit>Paste Special>Values>OK>Esc.

You can miss a step if you wanted to.

You don't need formulas in column B.

Enter 1000 in B1 or any cell outside Column A

Copy that cell.

Select the range in column A and Edit>Paste Special>Multiply>OK>Esc.


Gord Dibben MS Excel MVP