NUMBERASWORDS Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| Line 26: | Line 26: | ||
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: | ||
<div style="display: block; padding: 1em; margin: 0 0 10px; font-size: 13px; line-height: 1.65; color: black; word-wrap: break-word; background-color: #f9f9f9; border: 1px solid #ddd; border-radius: 4px;"><nowiki>NUMBERASWORDS(SUMM({{Task.Set price}}*{{Task.Amount}}); 0; "en")</nowiki></div> | <div style="display: block; padding: 1em; margin: 0 0 10px; font-size: 13px; line-height: 1.65; color: black; word-wrap: break-word; background-color: #f9f9f9; border: 1px solid #ddd; border-radius: 4px;"><nowiki>NUMBERASWORDS(SUMM({{Task.Set price}}*{{Task.Amount}}); 0; "en")</nowiki></div> | ||
== Go To == | |||
Revision as of 13:33, 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")