Try this UDF . It works.
UDF code
How to Use UDF code:![]()
Function ConToFormula(Ip As String) ConToFormula = Evaluate(Replace(Ip, """", "")) End Function
In the developer tab click--> Visual Basic
VB window opens
Insert--> Module
Paste the code.
Close the VB window.
Now UDF is available in Function List
Save file as .xlsm
Bookmarks