WorksheetFunction.NumberValue (Excel)

Converts text to number in a locale-independent manner.

NumberValue (Arg1, Arg2, Arg3)

Dim strArg1 As String: strArg1 = 
Dim strArg2 As String: strArg2 = 
Dim strArg3 As String: strArg3 = 
Dim dblNumberValue As Double
dblNumberValue = WorksheetFunction.NumberValue(Arg1:=strArg1, Arg2:=strArg2, Arg3:=strArg3)

Arguments

Arg1 (String) - String representing the number that you want to convert.

Arg2 (String) - Character used as the decimal separator in the string.

Arg3 (String) - Character used as the group separator in the string.