VALUE (PQL - xl)

This function converts a text string that is a number to a numeric value

  • Library: PQL \ Spreadsheet \ Text
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

VALUE(text)

Function Arguments

Name

Description

Type

Optional

text

Number in quotation marks or a reference to a cell with the text

String

Comments

This function is the same as the Microsoft Excel 'VALUE' function - using the same inputs, logic and outputs.