Formula results.

[Guest]

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.

 

[N Harkawat]

Copy -> Paste Special->Values

 

[Guest]

Hi

Select the cell, type Ctrl+C (copy) and then click on Edit/Paste
Special/Values.

 

[Guest]

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