Changing Cell contents from formula to the actual result
 

I'm not sure how to word this.. but here goes.

I have an old spreadsheet with a client's price list. The client
faxed their new price list to me which should be the old price +15%.

In our spreadsheet, I'm checking their calculations by using a formula
to add 15% to the old price. Once I check the list they sent and let
them know which are incorrect, I need the cell contents to be the
result of the formula and not the formula itself.

For example, cell A1's value is $111.85. Cell B1's value is =A1+
(A1*15%). Cell B1 displays $128.63.

I check it against the client's fax and the numbers match.

Now I need the value of cell C1 to be $128.63 - no formula, just the
formula's results.

How can I acheive this without manually typing the value?

Changing Cell contents from formula to the actual result
 

On Thu, 10 Jan 2008 09:57:48 -0800 (PST), wrote:

I'm not sure how to word this.. but here goes.

I have an old spreadsheet with a client's price list. The client
faxed their new price list to me which should be the old price +15%.

In our spreadsheet, I'm checking their calculations by using a formula
to add 15% to the old price. Once I check the list they sent and let
them know which are incorrect, I need the cell contents to be the
result of the formula and not the formula itself.

For example, cell A1's value is $111.85. Cell B1's value is =A1+
(A1*15%). Cell B1 displays $128.63.

I check it against the client's fax and the numbers match.

Now I need the value of cell C1 to be $128.63 - no formula, just the
formula's results.

How can I acheive this without manually typing the value?

Select B1 (or any range in column B)
Edit/Copy
Select C1
Edit/Paste Special Values
--ron

Changing Cell contents from formula to the actual result
 

On Jan 10, 12:21*pm, Ron Rosenfeld wrote:
On Thu, 10 Jan 2008 09:57:48 -0800 (PST), wrote:
I'm not sure how to word this.. but here goes.

I have an old spreadsheet with a client's price list. *The client
faxed their new price list to me which should be the old price +15%.

In our spreadsheet, I'm checking their calculations by using a formula
to add 15% to the old price. *Once I check the list they sent and let
them know which are incorrect, I need the cell contents to be the
result of the formula and not the formula itself.

For example, cell A1's value is $111.85. *Cell B1's value is =A1+
(A1*15%). *Cell B1 displays $128.63.

I check it against the client's fax and the numbers match.

Now I need the value of cell C1 to be $128.63 - no formula, just the
formula's results.

How can I acheive this without manually typing the value?

Select B1 (or any range in column B)
Edit/Copy
Select C1
Edit/Paste Special Values
--ron- Hide quoted text -

- Show quoted text -

thank you so much