SumInWords Function for LO 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 in writing in Ukrainian, but in LibreOffice Calc there is no 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: The language of the text is 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 LO 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 .

Or its free version YouLibreCalc .

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