On Friday, 24 May 2013 10:30:31 UTC+8, Alex Skinner wrote:
How can I store calculations using a currency exchange rate (stored in A1 for example) but not have the result change when the exchange rate is update?

I do not want to store each exchange rate variation in a new location every time it changes.

Thanks once again Garry,

Your suggestion doesn't seem to do what I want.
The Value function converts a text string that represents a number to that number and so is not useful in this instance.

In more detail my question is:
I store a Rate (.95) in A1
Elsewhere in the sheet I might have an amount $2 in A5.
I wish the result of the calculation $A$1*A5 to be stored in C5
Next an amount of $3 in A6 and calculated value $A$1*A6 in C6

At some future time the rate changes to .97 and I wish to use this value in future calculations. All previous results in Column C are automatically updated.

If I could store the calculated value in C then no recalculation would occur.

I know that I could Copy the cells and paste as Values to achieve this result but it is cumbersome and not practical for a data entry person.

There must be many occasions where this feature is desired but I can't find any reference, even in the Excel Bible.

Alex