TEXT (Report Builder 1.0)

Converts a numeric value to text.

Syntax

TEXT(value)

value

Indicates the number to convert to a string.

Remarks

  • Converting a numeric value, formula, or field to a text string allows you to concatenate text strings or perform other text functions on the value.

Example

Formula

Result

("There are " & TEXT(#Product Inventories)) & " product inventories from which to select."

Returns the following sentence: There are 1069 product inventories from which to select.