NUMERALSTOTEXT ER function
The NUMERALSTOTEXT function returns the specified number as a String value after it has been spelled out (that is, converted to text strings) in the specified language.
Syntax
NUMERALSTOTEXT (number, language, currency, print currency name flag, decimal points)
Arguments
number: Integer or Real
A numeric value that specifies the number that must be spelled out.
language: String
A String value that represents the language code.
currency: String
A String value that represents the currency code.
print currency name flag: Boolean
A Boolean value that indicates whether a currency name must be added to the spelled-out text.
decimal points: Integer
An Integer value that indicates the number of decimal places that the spelled-out text should have.
Return values
String
The resulting text value.
Usage notes
The language code is optional. If it's defined as an empty string, the language code for the running context is used. The default language code is EN-US. The language code for the running context is defined in a Folder or File element of the Electronic reporting (ER) format that is running.
The currency code is optional. If it's defined as an empty string, the company currency for the running context is used.
Note
The print currency name flag and decimal points arguments are analyzed only for the following language codes: CS, ET, HU, LT, LV, PL, and RU. Additionally, the print currency name flag argument is analyzed only for companies where the country's or region's context supports declension of currency names.
Example 1
NUMERALSTOTEXT (1234.56, "EN-US", "", false, 2) returns "One Thousand Two Hundred Thirty Four and 56".
Example 2
NUMERALSTOTEXT (120, "PL", "", false, 0) returns "Sto dwadzieścia".
Example 3
NUMERALSTOTEXT (120.21, "RU", "EUR", true, 2) returns "Сто двадцать евро 21 евроцент".