copy cell results and not underlying formulas
Right click in the cell containing the formula and choose 'copy'.
Right click in the cell where you wish to paste the value and choose "Paste
Special".
Then click on:
<Values
<OK
<Esc
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"john.jacobs71" wrote in message
...
This is very basic I am sure, but how do you copy and paste the results of
a
cell which is the product of a formula to a different cell without having
the
formula tag along and operate on the cells which relate to the target cell
in
the same relation that it relates to the copied cell???
|