TEXT (PQL - xl)

This function formats a number and converts it to text

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

Syntax

TEXT(value, format text)

Function Arguments

Name

Description

Type

Optional

value

Value requires numeric data or a reference to a cell that contains numeric data

Number

format text

The text argument requires a string

String

Comments

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