How to Convert all Formulas into Values in Excel
Sub ConvertToValues()
With ActiveSheet.UsedRange
.Value = .Value
End With
End Sub
Open Excel Sheet
Press Alt + F11 Key
Go to the Insert Menu and Click on new Module
in New Module copy and paste the above VBA code and save.