If you know the content of a string is a number, there is no need to convert it to an integer or float if you are going to use it in calculations.
Am I missing something.? See below code:
Dim strValue As String
Dim Result As Float
strValue = "100"
Result=Sqrt(strValue)
Msgbox("The square root of " & strValue & " is " & Result,"")