SpellNumber Function for LO Calc

SPELLNUMBER() Description

The SPELLNUMBER() function is designed to convert a number or sum written in digits into text in English.

This function allows you to convert numbers to words in any currency using a formula, for example, the number 22.50 will be read as "Twenty Two Dollars and Fifty Cents" or "Twenty Two Pesos and Fifty Centavos" .

This can be very useful if you use LO Calc as a template for filling out checks or other accounting documents.

Main Features Functions SPELLNUMBER

Syntax:

=SPELLNUMBER(Amount; [CurrNameSgl]; [CurrNamePlr]; [CentNameSgl]; [CentNamePlr]; [Format]; [CurrPlace]; [ZeroMod])

Parameters:

• Amount: The number to be converted to text.
• [CurrNameSgl]: Optional. The name of the monetary unit in the singular.
• [CurrNamePlr]: Optional. The plural name of the currency.
• [CentNameSgl]: Optional. The name of the coin in the singular.
• [CentNamePlr]: Optional. The name of the exchange coin in the plural.
• [Format]: Optional. Text display format:
  0. We display the full amount in writing with the name for the currency and loose change.
  1. The amount is in words only for the whole part.
  2. Amount in words only for the fractional part.
  3. Amount in words with a special format for the fractional part, namely: "dd/100" .
  4. Amount in words with a special format for the fractional part, namely: "ddd/1000" .
  5. Amount in words with a special format for the fractional part in thousandths format.
• [CurrPlace]: Optional. Place the currency name at the end of the text (0) or at the beginning (1).
• [ZeroMod]: Optional. Whether to display zero values of the fractional part in writing: no (0), yes (1).

Example Usage

The SPELLNUMBER() function is easy to use. You just need to enter any number into the formula, specify the currency name for integer and fractional values, and, if necessary, specify additional parameters for the desired text display format, and LO Calc automatically converts it to text:

=SPELLNUMBER(13561,32; "Dollar"; "Dollars"; "Cent"; "Cents"; ""; ""; "")

We will have the following result:

This example uses the following values:

• Amount: A2 - The number to be converted to text (13561,32) .
• CurrNameSgl: B2 - Name of the monetary unit in the singular ("Dollar") .
• CurrNamePlr: C2 - Name of the monetary unit in the plural ("Dollars") .
• CentNameSgl: D2 - Name of the coin in the singular ("Cent") .
• CentNamePlr: E2 - The name of the coin in the plural ("Cents") .
• Format: F2 - By default (0). Display the full amount in words with the name for the currency and change coin ("") .
• CurrPlace: G2 - Default (0). Place the currency name at the end of the text ("") .
• ZeroMod: H2 - Default (0). Do not display the zero fractional part in writing ("") .

Download extension

You can use the function SPELLNUMBER() 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 .