DECIMAL
function DECIMAL(arg1: string = null, arg2: number = null): number | string | booleanDescription
Converts a text representation of a number in a given base into a decimal number.
Parameters
- arg1
stringdefault: null Is the number that you want to convert.
- arg2
numberdefault: null Is the base Radix of the number you are converting.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.DECIMAL(101, 2));