Changing cell from formula to data.

T

TimM

Is there a way to change a cell from a formula (that is returning data) to
the data it is returning. I realy hop it it becuse it would help out a ton.
 
M

Michael

If you select the cell and copy then edit - pastes special - values on the
cell you will have the value and not the formula. HTH
 
B

B. R.Ramachandran

Hi,

Select the cell(s) containing the formula(s), "Edit" --> "Copy" --> "Edit"
--> "Paste Special" --> "Values" --> "OK".

This would change formula results to standalone data. However, please note
that the formulas are permanently lost.

Regards,
B. R. Ramachandran
 
Top