Function SpellNumber

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 into words in any currency using a formula, for example, the number 22,50 will read as "Twenty Two Dollars and Fifty Cents" or "Twenty Two Pesos and Fifty Centavos".

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

Key Features of the SPELLNUMBER Function

Syntax:

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

Parameters:

• Amount: The number to be converted into text.
• [CurrNameSgl]: Optional. Name of the monetary unit in singular.
• [CurrNamePlr]: Optional. Name of the monetary unit in plural.
• [CentNameSgl]: Optional. Name of the fractional currency in singular.
• [CentNamePlr]: Optional. Name of the fractional currency in plural.
• [Format]: Optional. Text display format:
  0. Display the full amount in words with names for currency and fractional currency.
  1. Amount in words only for the integer 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. Placement of the monetary unit name at the end of the text (0) or at the beginning (1).
• [ZeroMod]: Optional. Whether to display zero fractional part values in words: 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 name of the monetary unit for integer and fractional values, and, if necessary, specify additional parameters for the required text display format, and Excel (Calc) will automatically convert it into text:

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

We will get the following result:

The following values are used in this example:

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

Download extension

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

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