NUMBERVALUE
function NUMBERVALUE(arg1: string = null, arg2: string = null, arg3: string = null): numberDescription
Converts text to a number, in a locale-independent way.
Parameters
- arg1
stringdefault: null The string representing a number to convert.
- arg2
stringdefault: null The character used as the decimal separator in the string.
- arg3
stringdefault: null The character used as the group separator in the string.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.NUMBERVALUE("2.500,27", ",", "."));