Changing cell from formula to data.
 

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.


--
Thanks
TimM

Changing cell from formula to data.
 

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
--
Sincerely, Michael Colvin


"TimM" wrote:

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.


--
Thanks
TimM

Changing cell from formula to data.
 

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

"TimM" wrote:

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.


--
Thanks
TimM