Formula results.
 

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.

Copy - Paste Special-Values

"PeterP" wrote in message
...
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.

Hi

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

--
Andy.


"PeterP" wrote in message
...
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.

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

OR

1)Click on the cell
2)EditCopy
3)EditPaste SpecialValues

Does that help?

Ron