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.
[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:
Display the full amount in words with names for currency and fractional currency.
Amount in words only for the integer part.
Amount in words only for the fractional part.
Amount in words with a special format for the fractional part, namely: "dd/100".
Amount in words with a special format for the fractional part, namely: "ddd/1000".
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: