NUMBERASWORDS Function: Difference between revisions
From Planfix
(→Go To) |
No edit summary |
||
| Line 23: | Line 23: | ||
**en — english | **en — english | ||
**fr — french | **fr — french | ||
**de — german | |||
== Example == | == Example == | ||
To display a number in words a document, use a function like this: | To display a number in words a document, use a function like this: | ||
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
- de — german
Example
To display a number in words a document, use a function like this:
NUMBERASWORDS(SUMM({{Task.Set price}}*{{Task.Amount}}); 0; "en")