Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculation based on cell format results Japs Excel Discussion (Misc queries) 2 May 18th 07 08:42 PM
NETWORKDAYS calculation returns inconsistent results Analowl Excel Worksheet Functions 1 August 30th 06 02:28 AM
Help please... Simple calculation - with unexpected results MLK Excel Worksheet Functions 7 July 29th 06 12:03 AM
How do I make the now() static and not change with calculation? Helping with time Excel Worksheet Functions 2 February 12th 06 07:20 PM
Calculation on SUMIF Results Andy B Excel Worksheet Functions 3 October 9th 05 04:47 AM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"