Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Replacing A Column Of Numbers
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Replacing A Column Of Numbers
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing numbers | New Users to Excel | |||
replacing a range of numbers | Excel Worksheet Functions | |||
Replacing a Range of Numbers | Excel Worksheet Functions | |||
replacing numbers in a cell | Excel Worksheet Functions | |||
using treater than and replacing numbers | Excel Worksheet Functions |