Number.ToText
Syntax
Number.ToText(number as nullable number, optional format as nullable text, optional culture as nullable text) as nullable text
About
Converts the numeric value number
to a text value according to the format specified by format
.
The format is a text value indicating how the number should be converted. For more details on the supported format values, go to Standard numeric format strings and Custom numeric format strings.
An optional culture
may also be provided (for example, "en-US") to control the culture-dependent behavior of format
.
Example 1
Convert a number to text without specifying a format.
Usage
Number.ToText(4)
Output
"4"
Example 2
Convert a number to exponential format.
Usage
Number.ToText(4, "e")
Output
"4.000000e+000"
Example 3
Convert a number to percentage format with only one decimal place.
Usage
Number.ToText(-0.1234, "P1")
Output
"-12.3 %"