Thread: Convert cells updated by formula to Absolute values

Dear Experts..

In my sheet there's Column nD(Total Value) has formula Column $A(Item Cost) * Column nB(Item Rate)

As Example ;
i need to change 'Item Cost' when Row No Reaches 10 due to market fluctuation. If i change $A then old price totals are also change.
In this case; How can i freeze that column D current calculated values to avoid change update them with new price.

Actually i need a way to convert column D values to Absolute value after 1st calculation!!

Thanks