Converting a Formula to Value - Excel Quick Tips
This Short video cover's "Converting a Formula to Value in MS Excel".
Here are some reasons why you need to replace a formula with its result value.
If you are sending a report to someone without its source data then it’s better to convert all the formulas into static values.
Some functions are volatile and when you update your worksheet their value will recalculate.
To prevent the end-user to make any change in the calculation.
Static values are easily editable and anyone can copy-paste them easily.
You don’t want to confuse end-user with complex formulas.
Correction: Cell L5:L11 on third method is date formatted that's why it is showing date.