delete the formula

[tonyk]

I made a form with formulas. Now i made some changes and need to delete
the formula but not the result from that formula. Is there no way just
to clear the formula? I know it has the clear content option but no
clear formula. I even copy the results but it also copied the formula
along with it. Please help.

 

[Ardus Petus]

Edit>Copy
Edit>Paste special, check Values

HTH

 

[Dave Peterson]

And if you only have one cell...

Select the cell
Hit F9 (to evaluate the formula as a value)
hit Enter

 

[tonyk]

Thanks, Dave Peterson