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?
|