VALUE
function VALUE(arg1: string = null): numberDescription
Converts a text string that represents a number to a number.
Parameters
- arg1
stringdefault: null The text enclosed in quotation marks or a reference to a cell containing the text which will be converted to a number.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.VALUE("$3.50"));