NUMBERASWORDS Function

The NUMBERASWORDS function

This is a function that returns a number as words. Only the integer part of the number is written out.

Format:

NUMBERASWORDS(number; Output; "language")

Where:

• number — is a number or formula
• Output — defines how the numeral will be displayed (from 0 to 6)
• language — string that specifies the output language. If left empty (""), the language of the user generating the document is used.

Languages and their Output methods:

• English ("en")
  • 0-3 — default (cardinal number)
  • 4-6 — capitalized default

• German ("de")
  • 0 — default (gender-neutral)
  • 1 — written in feminine
  • 2 — written in masculine
  • 3 — written in neuter
  • 4 — capitalized in feminine
  • 5 — capitalized in masculine
  • 6 — capitalized in neuter

• French ("fr")
  • 0 — default (cardinal number)
  • 1 — written in feminine
  • 2 — written in masculine
  • 4 — capitalized in feminine
  • 5 — capitalized in masculine

Example

To display a number as words in a document, use the following function:

NUMBERASWORDS(SUM({{DataTag.Service.Cost}}*{{DataTag.Service.Quantity}}); 2; "en")

Go To

• Standard functions