SpellNumber Function for LibreOffice Calc

SPELLNUMBER() Description

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

This function allows you to convert numbers to words in any currency using a formula, such as a 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 to fill 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 name of the monetary unit in the plural.
• [CentNameSgl]: Optional. The name of the exchange 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 exchange coin.
  1. The amount in writing is only for the whole part.
  2. The amount in writing is only for the fractional part.
  3. The sum in writing with a special format for the fractional part, namely: "dd/100".
  4. The amount in writing with a special format for the fractional part, namely: "ddd/1000".
  5. The amount in writing with a special format for the fractional part in the format of thousands.
• [CurrPlace]: Optional. Placing 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 in the formula, specify the name of the currency for integer and fractional values, and, if necessary, specify additional options for the desired text display format, and LibreOffice Calc will automatically convert it to text:

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

We will have the following result:

This example uses the following values:

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

Extension "YouLibreCalc.oxt"

You can use the function SPELLNUMBER() by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.