NUMBERASWORDS Function: Difference between revisions

From Planfix
Jump to: navigation, search
No edit summary
Line 29: Line 29:


== Go To ==
== Go To ==
*[[Standard functions]]

Revision as of 13:40, 25 November 2025

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