You need to <copy the cell where the formula is, then click to the
other sheet and cell, then Edit | Paste Special | Values | OK and <esc
or <enter. This will fix the values, whereas copy/paste will copy the
formula.

Hope this helps.

Pete