NUMBERASWORDS Function
Converts a number to text in the selected language.
Format
NUMBERASWORDS(number; type; language[; precision])
Where:
- number — is a number or formula
- Type:
- 0 — standard form
- 1 — feminine
- 2 — masculine
- 3 — neuter
- 4, 5, 6 — the corresponding gender with an initial capital letter.
- Language — a code in quotation marks, for example, "en","de", or "fr". An empty string ("") means the user's language.
- Precision — an optional integer from 0 to 4: the maximum number of decimal places to include. Extra digits are discarded without rounding. If this parameter is omitted, only the integer part is returned. Trailing zeros are not added to the fractional part.
Languages and their Output methods:
- English ("en")
- 0-3 — default (cardinal number)
- 4-6 — capitalized default
- German ("de")
- 0 — default (gender-neutral)
- 1 — written in feminine
- 2 — written in masculine
- 3 — written in neuter
- 4 — capitalized in feminine
- 5 — capitalized in masculine
- 6 — capitalized in neuter
- French ("fr")
- 0 — default (cardinal number)
- 1 — written in feminine
- 2 — written in masculine
- 4 — capitalized in feminine
- 5 — capitalized in masculine
Examples
NUMBERASWORDS(1.259;0;"en") → one
NUMBERASWORDS(1.259;0;"en";2) → one point two five
NUMBERASWORDS(1.259;4;"en";1) → one point two
The word forms used for fractional numbers follow the rules of the selected language. If number spelling is not supported in that language, English is used.