NUMBERTOTEXT

The NUMBERTOTEXT function converts a character number to a text item that looks like the original object.

You can use NUMBERTOTEXT when you need an object that is defined as a number converted to an object defined as text. This is useful when you need to concatenate text, however, the FROMNUMBER function provides greater flexibility in specifying the format of the resulting text item.

Syntax:
NUMBERTOTEXT (single-number-expression)
Meaning:
NUMBERTOTEXT (number_to_convert)
Returns:
A single text item

The resulting text looks like the input argument. The result is truncated, if necessary.

Examples

  • NUMBERTOTEXT (ROUND (1000 - 24.75, 3))

    This example converts the result of the calculation (rounded to 3 decimal places) to text, resulting in 975.250.

  • NUMBERTOTEXT (PurchaseNumber)

    This example converts PurchaseNumber from a number to text.

Related functions

  • FROMNUMBER
  • TEXTTONUMBER
  • TODATETIME
  • TONUMBER

Feedback