Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation results as static data not formula.
I know this is an easy one for you wizzes, but it escapes me at the moment
and I never seem to have the right terminology to look up what I am trying to do. I have two columns of data (A, B) and a third that is the result of a calculation of A & B (A*B=C). I need column C to become static data rather than the formula as columns A & B will eventually be removed. I know it's simple - sorry and thanks! Dawn |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation results as static data not formula.
One way:
Select column C. Copy. Choose Edit/Paste Special, selecting the Values radio button. Click OK. In article , tcidawn wrote: I know this is an easy one for you wizzes, but it escapes me at the moment and I never seem to have the right terminology to look up what I am trying to do. I have two columns of data (A, B) and a third that is the result of a calculation of A & B (A*B=C). I need column C to become static data rather than the formula as columns A & B will eventually be removed. I know it's simple - sorry and thanks! Dawn |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation results as static data not formula.
In C1: =A1*B1 (hit F9 key instead of hit Enter key)
"tcidawn" wrote: I know this is an easy one for you wizzes, but it escapes me at the moment and I never seem to have the right terminology to look up what I am trying to do. I have two columns of data (A, B) and a third that is the result of a calculation of A & B (A*B=C). I need column C to become static data rather than the formula as columns A & B will eventually be removed. I know it's simple - sorry and thanks! Dawn |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation results as static data not formula.
Thank you so much for your help!
"Teethless mama" wrote: In C1: =A1*B1 (hit F9 key instead of hit Enter key) "tcidawn" wrote: I know this is an easy one for you wizzes, but it escapes me at the moment and I never seem to have the right terminology to look up what I am trying to do. I have two columns of data (A, B) and a third that is the result of a calculation of A & B (A*B=C). I need column C to become static data rather than the formula as columns A & B will eventually be removed. I know it's simple - sorry and thanks! Dawn |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation results as static data not formula.
Thank you so much for your help!
"JE McGimpsey" wrote: One way: Select column C. Copy. Choose Edit/Paste Special, selecting the Values radio button. Click OK. In article , tcidawn wrote: I know this is an easy one for you wizzes, but it escapes me at the moment and I never seem to have the right terminology to look up what I am trying to do. I have two columns of data (A, B) and a third that is the result of a calculation of A & B (A*B=C). I need column C to become static data rather than the formula as columns A & B will eventually be removed. I know it's simple - sorry and thanks! Dawn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation based on cell format results | Excel Discussion (Misc queries) | |||
NETWORKDAYS calculation returns inconsistent results | Excel Worksheet Functions | |||
Help please... Simple calculation - with unexpected results | Excel Worksheet Functions | |||
How do I make the now() static and not change with calculation? | Excel Worksheet Functions | |||
Calculation on SUMIF Results | Excel Worksheet Functions |