How to convert formulas into values?

To covert formulas into values in a range. First select the range of data in excel sheet and then run this macro.

Sub value()

Dim cell As Range

For Each cell In Selection

cell.value = cell.value

Next cell

End Sub

To insert this macro press Alt+11 in excel sheet and then go to insert and click Module. After inserting module copy this macro. You can attach this macro with a button or press F5 to run it.

Contact Us

Learn Excel Tricks