NUMBERASWORDS Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
}} | }} | ||
The function returns a number written out in words. Only the integer part of the number is converted; the fractional part is ignored. | 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") | NUMBERASWORDS(number; OutputMode; "language") | ||
Revision as of 13:26, 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")