View Single Post
  #4   Report Post  
RagDyer
 
Posts: n/a
Default

You copy the cell to itself, and then stipulate to paste only the *values*.

Right click in the cell and choose "Copy".
Right click again and choose "PasteSpecial".
Click on "Values", then <OK, then <Esc.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Gary S." <Gary wrote in message
...
I'd like to copy the numeric result of a formula in an Excel cell, but not
the formula. Is there an addressing mode or technique that does this?