Formula results.

P

PeterP

In excel how do I remove a formula and leave just the resultant value in that
cell?
I'm fairly sure that there is a way to "remove" the formula and keep just
the value but, I can't seem to find it now.

Thanks,

Pete.
 
R

Ron Coderre

1)Click on the cell
2)press [F2] (edit)
3)Press [F9] (calc)
4)Press [Enter]

OR

1)Click on the cell
2)Edit>Copy
3)Edit>Paste Special>Values

Does that help?

Ron
 
Top