View Single Post
  #2   Report Post  
 
Posts: n/a
Default

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.