Hi y'all,

I feel like this should be a fairly straightforward task, but I don't know how to go about it. I'm hoping you can help?

Let's say I have a cell, (B1, for example), with a simple forumla in it:

=SUM(A1:A3)

And, let's say that A1 = 2, A2 = 4, and A3 = 6.

The forumla will produce a value of "12" in the cell B1.

Is there a simple way of replacing the forumla in B1 with the number 12? That is, I'm looking for a way to replace a formula with the result of the formula... locking the value into the cell, as it were.

Any help would be greatly appreciated. Thanks!


- M