The SUMINWORDS() function is designed to convert a number or amount written in digits into text.
Quite often, for accounting purposes, the value of a trade transaction needs to be written out in words. For example, the amount 10 568,23 should be displayed in words as "Десять тисяч п'ятсот шістдесят вісім гривень 23 копійки", meaning the amount in words in Ukrainian is needed, but in Excel (LibreOffice Calc) there is no standard function for such purposes.
Key Features of the SUMINWORDS Function
Syntax:
=SUMINWORDS(Amount; LangCode; CurrCode)
Parameters:
Amount: The number to be converted into text.
LangCode: The language of the text in the form of a two-letter code. Three languages are available: "UK" - Ukrainian, "RU" - Russian, and "EN" - English.
CurrCode: The currency in the form of a three-letter code. Three currencies are available: "UAH" - Hryvnia, "RUB" - Ruble, and "USD" - Dollar.
Example of Usage
The SUMINWORDS() function is simple to use. You just need to enter any number into the formula, specify the language in which you want to display the number, and also indicate the currency of the amount, and Excel (Calc) will automatically convert it into text:
=SUMINWORDS(Amount; LangCode; CurrCode)
We will get the following result:
The following values are used in this example:
Amount:A2 - The number to be converted into text (123562,31).
LangCode:B2 - Ukrainian language in the form of a two-letter code ("UK").
CurrCode:C2 - Ukrainian Hryvnia in the form of a three-letter code ("UAH").
