To lock these numeric values, you need to delete the formula without deleting the calculated results. This is accomplished using Excel's copy and paste feature.

A client needs to keep track of frequently changing commodity prices and capture the most current figure and eventually copy it into a formula that calculates its resell price. I’m sure Excel can ...