I'm not quite sure of the terminology involved in this problem. What I have to do is calculate in column B some values dependent on the current contents of column A. This I do with a formula as there are a lot of rows (the formula is `=90 - A1`

).

Then, given this new value in column B, to set the value in column A to the new value of column B (using `=B1`

). This gives me zero in all cases (rather than the circular reference I was expecting).

What I'd like to do is fix the current value of column B as it has been calculated, so I can then set the value of column A as I like. Is there any way to do this?

Edit: the values must end up in columns A and B, although I can scribble in any other column as necessary.

needthe result value in Column A? I've never used Excel that much, but I'd go for a more procedural approach and introduce a new Column C. What you can do is copy the whole Column B and paste it using the raw values instead of the formula. – slhck♦ May 20 '11 at 9:45