Skip to main content

VALUE

Converts a text string that represents a number to a number.

Syntax

expression.VALUE(arg1);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

NameRequired/OptionalData typeDefaultDescription
arg1RequiredApiRange | ApiName | stringThe text enclosed in quotation marks or a reference to a cell containing the text which will be converted to a number.

Returns

number

Example

This example shows how to convert a text string that represents a number to a number.

// How to get number from a text.

// Use a function to return a number from a string.

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.VALUE("$3.50"));