NUMBERASWORDS Function: Difference between revisions
From Planfix
No edit summary |
(→Go To) |
||
| 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")