instantaneous cell value

[bk]

This is probably incredibly simple but I've been going in circles with it for
some time. I'm looking for a way to grab and hold the instantaneous value of
a cell whose contents are constantly being updated. Any thoughts?

 

[Pete]

You can "fix" the values of a cell by <copy>, then select another cell
(maybe in another sheet) and Edit | Paste Special | Values | OK. This
would leave the formula in the original cell to continue to update
itself.

Hope this helps.

Pete

 

[bk]

thanks for the reply. this works as a "manual" solution but how can I assign
only the contents of a cell in a formula?