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