TOP

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:

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:

Example of using the SPELLNUMBER() function
Example of using the SPELLNUMBER() function

The following values are used in this example:

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).


This function is also available in the following extensions: YLC LightYLC FunctionsYLC Utilities

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel