SumInWords Function for Excel

SUMINWORDS() Description

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

Quite often, for accounting purposes, the value of a trade transaction needs to be spelled out in words. For example, the amount 10,568.23 display in writing how "Десять тисяч п'ятсот шістдесят вісім гривень 23 копійки" , i.e. the required sum in Ukrainian language, but there is no standard function for such purposes in Excel.

Main Features Functions SUMINWORDS

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 in the formula, specify the language in which you want to display the number, and specify the currency of the amount of money, and Excel will automatically convert it to text:

=SUMINWORDS(Amount; LangCode; CurrCode)

We will have the following result:

This example uses the following values:

• Amount: A2 - Number to be converted to text (123562,31) .
• LangCode: B2 - the 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 the extension

You can use the SUMINWORDS() function by installing the free extension YouLibreCalc.xlam .

After that, this function will be available in all files that will be opened in Excel.