software

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

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 Colvinquot;TimMquot; wrote:

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

Hi,

Select the cell(s) containing the formula(s), quot;Editquot; --gt; quot;Copyquot; --gt; quot;Editquot;
--gt; quot;Paste Specialquot; --gt; quot;Valuesquot; --gt; quot;OKquot;.

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

Regards,
B. R. Ramachandran

quot;TimMquot; wrote:

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