Replacing A Column Of Numbers

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

On 14/03/2010 16:35, Bob wrote:
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

Copy column B.

Select A1 and EditPaste SpecialValuesOKEsc.

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 EditPaste SpecialMultiplyOKEsc.


Gord Dibben MS Excel MVP

On Sun, 14 Mar 2010 12:35:20 -0400, Bob wrote:

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