SumInWords Function for Excel (Calc)

SUMINWORDS() Description

The SUMINWORDS() function is designed to convert a number or sum written in numbers into text.

Quite often, for accounting purposes, the cost of a trade transaction needs to be written down in words. For example, the amount 10,568.23 to express in words as "Десять тисяч п'ятсот шістдесят вісім гривень 23 копійки" , that is, the required amount is written in Ukrainian, but LibreOffice Calc does not have a standard function for such purposes.

Main Features of the SUMINWORDS Function

Syntax:

=SUMINWORDS(Amount; LangCode; CurrCode)

Parameters:

• Amount: The number to be converted to text.
• LangCode: Text language in the form of a two-letter code. Three languages are available: "UK" - Ukrainian, "RU" - Russian and "EN" - English.
• CurrCode: Currency in the form of a three-letter code. Three currencies are available: "UAH" - hryvnia, "RUB" - ruble, and "USD" - dollar.

Example Usage

The SUMINWORDS() function is easy to use. You just need to enter any number into the formula, specify the language in which you want the number to be displayed, and the currency of the amount, and Excel (Calc) automatically converts it to text:

=SUMINWORDS(Amount; LangCode; CurrCode)

We will have the following result:

This example uses the following values:

• Amount: A2 - The number to be converted to 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") .

Download extension

You can use the function SUMINWORDS() by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel (LibreOffice Calc) .