NUMBERASWORDS Function

From Planfix
Revision as of 13:40, 25 November 2025 by Dmitri (talk | contribs) (→‎Go To)
Jump to: navigation, search

The function returns a number written out in words. Only the integer part of the number is converted; the fractional part is ignored.

Format

NUMBERASWORDS(number; OutputMode; "language")

Where:

  • number — a numeric value or a formula
  • OutputMode:
    • 0 — standard output
    • 1 — words in feminine gender
    • 2 — words in masculine gender
    • 3 — words in neuter gender
    • 4 — words in feminine gender, starting with a capital letter
    • 5 — words in masculine gender, starting with a capital letter
    • 6 — words in neuter gender, starting with a capital letter
  • language
    • "" (empty) — uses the language of the user who is generating the document
    • en — english
    • fr — french

Example

To display a number in words a document, use a function like this:

NUMBERASWORDS(SUMM({{Task.Set price}}*{{Task.Amount}}); 0; "en")


Go To