FROMNUMBER
The FROMNUMBER function converts a number to a text string of a specified format.
Use FROMNUMBER when you need to convert a number item into a string for parsing or concatenation.
- Syntax:
FROMNUMBER (single-character-number-item
[ , single-text-expression] )- Meaning:
- FROMNUMBER (number_to_convert [ , number_format_string ] )
- Returns:
- A single character text item
FROMNUMBER returns the number specified by number_to_convert as a text item with the format specified by number_format_string. If number_format_string is not specified, number_to_convert will be returned in the same format as the number_to_convert.
The number_format_string must conform to the number format strings as described in the "Format strings" topic.
Examples
- Greeting = "You are caller number " + FROMNUMBER (SeqNo:.:History,
"{#','###}") + "!"
If the value of SeqNo is 2348192, this rule evaluates to "You are caller number 2,348,192!"
- "$" + FROMNUMBER(CurrentRate
Field:.:Schedule, "{#','###'.'2##2}")
If the value of CurrentRate Field is 15.875, "$15.88".
Related functions
- DATETONUMBER
- NUMBERTODATE
- NUMBERTOTEXT
- TONUMBER