Need an Excel cell value to freeze once entered
Posted on 2016-11-21
Mr. Google can't find this, but maybe I just don't know the term to search for.
I have a spreadsheet that tracks transactions in various currencies. The exchange values change daily. I have a cell with today's value, and when I make a deal the record for that deal records the USD equivalent of it based upon the cell value. But if the exchange rate changes tomorrow, the deal record will update. Instead of doing the math and entering a value, I would like the deal record to revert to just a value instead of a formula or somehow freeze once the other parameters of the deal are entered. I'm hoping for something that does not involve Visual Basic.