The ConvertNumberString method converts a string expression of a number to an Integer Variant, based on the specified locale. If successful, ConvertNumberString returns an Integer Variant containing the converted value; otherwise, Null.
DataFunctions.ConvertNumberString(Number, Locale)
The ConvertNumberString method is designed to accept only integers. Passing a floating-point number as the Number parameter results in an error. To convert floating-point numbers, use ConvertFloatString.
The following example uses ConvertNumberString to convert 123,000 from a string to a number:
StrNum = "123,000"
NNum = DataFunctions.ConvertNumberString(StrNum, &H0409)
In this example, the call to ConvertNumberString returns the following value:
123000