Locking in values
 

When an amount is entered in column B, column C looks up an array of rates
and does a calculation based on the currency in column A. The challenge is
locking in the amount in column C to reflect the conversion on the opening
date, as the rates are updated daily. Is the only solution Paste Special?