Copy as usual from the originating cell. When you click on the receiving
cell, select Edit-Paste Special. The menu presents some choices of what to
copy; one of them is "values."

"pjb" wrote in message
...
How can I copy the contents of a cell (the result of a formula) to another
worksheet without copying the formula. thanks.