Senior author, Open Source enthusiast.
Sunday, January 8, 2023 at 21:03

# LibreOffice Calc: How To Convert Numbers to Text

This tutorial will show you an example of converting numbers to words with a function in LibreOffice Calc. It works by translating number, say 1234, into English words one thousand two hundred thirty four. The function in question is NUMBERTEXT, that spells numbers, and MONEYTEXT, that spells money currencies, all with translations to multiple languages including Chinese, German, Japanese, Korean, and Indonesian.

Subscribe to UbuntuBuzz Telegram Channel to get article updates.

A1 = 10
A2 = 100
A3 = 1000
A4 = 10000
A5 = 100000
A6 = 1000000
A7 = 1234567890

# Basic Conversions

1. Write example numbers above in A1-A7 cells.
2. Write functions below in B1-B7 cells.

=NUMBERTEXT(A1) spells ten
=NUMBERTEXT(A2) spells one hundred
=NUMBERTEXT(A3) spells one thousand
=NUMBERTEXT(A4) spells ten thousand
=NUMBERTEXT(A5) spells one hundred thousand
=NUMBERTEXT(A6) spells one million
=NUMBERTEXT(A7) spells one billion, two hundred thirty-four million, five hundred sixty-seven thousand, eight hundred ninety

# Spelling Numbers in English

The basic use of this function is in these two formats:

`=NUMBERTEXT(Number) =MONEYTEXT(Number, Currency, Language)`

For example, to spell out a number:
=NUMBERTEXT(A4)
one thousand

To spell out money currency:
=NUMBERTEXT(A4, "USD", "en-us")
one thousand US dollar

More examples below.

# Spelling Numbers in Other Languages

Other than English, NUMBERTEXT supports spelling numbers in many other languages. See examples below:

Chinese: =NUMBERTEXT(A4, "zh-zh")

France: =NUMBERTEXT(A4, "fr-fr")

German: =NUMBERTEXT(A4, "de-de")

Indonesian: =NUMBERTEXT(A4, "id-id")

Japanese: =NUMBERTEXT(A4, "ja-ja")

Korean: =NUMBERTEXT(A4, "ko-ko")

Other languages may follow above examples with language code list in the end section. If your language is not supported yet, we encourage you to help contribute to the project (see last section).

# Spelling Numbers into Money Currencies in English

MONEYTEXT supports spelling numbers into money currencies in English.  See examples below:

Chinese Yen: =MONEYTEXT(A4, "CNY", "en-us")
Great Britain Pound sterling: =MONEYTEXT(A4, "GBP", "en-us")
European Euro: =MONEYTEXT(A4, "EUR", "en-us")
Thai Baht: =MONEYTEXT(A4, "THB", "en-us")
Japanese Yen: =MONEYTEXT(A4, "JPY", "en-us")
Korean Won: =MONEYTEXT(A4, "KRW", "en-us")

Spell the following:

Ten thousand Chinese yuan
Ten thousand pounds sterling
Ten thousand euro
Ten thousand Japanese yen
Ten thousand Korean won

# Spelling Numbers into Money Currencies in Their Local Languages

MONEYTEXT function also supports spelling numbers into money currencies in each ones local languages other than English.

Chinese Yuan in Chinese: =MONEYTEXT(A3, "CNY", "zh-zh")
Pound sterling in English: =MONEYTEXT(A3, "GBP", "en-uk")
Euro in French: =MONEYTEXT(A3, "EUR", "fr-fr")
Euro in German: =MONEYTEXT(A3, "EUR", "de-de")
Euro in Spanish (Espanol): =MONEYTEXT(A3, "EUR", "es-es")
Euro in Portuguese: =MONEYTEXT(A3, "EUR", "pt-pt")
Rupiah in Indonesian: =MONEYTEXT(A3, "IDR", "id-id")
Yen in Japanese: =MONEYTEXT(A3, "JPY", "ja-ja")
Won in Korean: =MONEYTEXT(A3, "KRW", "ko-ko")
Baht in Thai: =MONEYTEXT(A3, "THB", "th-th")
Philippine Peso in English:  =MONEYTEXT(A3, "PHP", "en-us")
Malaysian Ringgit in English: =MONEYTEXT(A3, "MYR", "ms-my")

Spell as the following:

US Dollar  🇬🇧🇺🇸
Ten thousand U.S. dollars

Chinese Yuan 🇨🇳

Euro, German 🇩🇪
Zehntausend Euro

Euro, French 🇫🇷
Dix-mille euros

Euro, Spanish 🇪🇸
Diez mil euros

Euro, Portuguese 🇵🇹
Dez mil euros

Indonesian Rupiah 🇮🇩
Sepuluh ribu rupiah

Japanese Yen 🇯🇵

Korean Won 🇰🇷
일만 원

Thai Baht 🇹🇭
หนึ่งหมื่นบาทถ้วน

Philippine Peso 🇵🇭
Ten thousand Philippine pesos

Malaysian Ringgit 🇲🇾
Sepuluh ribu Ringgit

# Notes

Several caveats we found with the current version of NumberText are as the following. For everyone wanting to contribute and fix the issues together, please visit the website. We hope these issue will be fixed immediately.
• cannot spell out Arabic
• cannot spell out Saudi Arabian Riyal (SAR), UAE Dinar (AED), and Philippine Peso (PHP) in their own local languages
• cannot spell out Indonesian Rupiah (IDR) in English

https://extensions.libreoffice.org/en/extensions/show/numbertext-1