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.

Do you need the 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

Use paste special, only paste the value of column B.
–
lamwaiman1988May 20 '11 at 9:53

@Gunbuster, @slhck, thank you; using paste special and an extra column has done it. @slhck, perhaps you could put that in as an answer.
–
Brian HooperMay 20 '11 at 9:58