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