How To Use NUMBERTEXT Function in OpenOffice Calc?

NUMBERTEXT Function is an add-in provided by OpenOffice that converts your numbers to words in OpenOffice Calc, similar to the SpellNumber function in Excel. In other words, you can convert a numeric value into words using this function.

Similar to Excel, OpenOffice Calc doesn’t have any built-in function to convert numbers to words. As OpenOffice is open-source software, it provides NUMBERTEXT as an add-in. This add-in consists of 2 functions: NUMBERTEXT and MONEYTEXT.

NUMBERTEXT converts numbers to words, and MONEYTEXT converts numbers to words with a given currency.

Let’s see the steps to install this add-in.

Key Takeaways

• NUMBERTEXT (numbers to words) and MONEYTEXT (numbers to words with currency format). Supports multiple languages (around 60+), including the Indian numbering system (lakh, crore), using codes like en-IN.
• Download extension → install → function becomes available across all files automatically.
• MONEYTEXT enhances functionality by converting numbers into currency-based text (INR, USD, etc.) with language control.

Install NUMERTEXT add-in in OpenOffice Calc in 3 Easy Steps

1. Click on the NUMBERTEXT extension page.
   
2. Download the extension from the green download button.
3. Install the extension on your PC.

Your NUMBERTEXT and MONEYTEXT Extension is ready to use.

How To Use the NUMBERTEXT Function?

NUMBERTEXT not only converts numbers to words in English but also in many other languages. Thus, you can convert “123456” to “One hundred twenty-three thousand four hundred and fifty-six”.

There is no direct function in OpenOffice to perform the above action. OpenOffice has created and published this extension on their website.

SYNTAX – NUMBERTEXT

=NUMBERTEXT(Cell Reference or Number)

OR

=NUMBERTEXT(Cell Reference or Number, Language)

Use the strings in ” ” marks.

Using the NUMBERTEXT Function in Calc

To use this function, you need either one string or two strings. Just by using the number string, it will convert the number to words. The second string is for language. NUMBERTEXT supports around 60 languages in which you can convert numbers to words.

Example:

Let’s convert some numbers using this function with and without the language option.

“123456” converts to “one lakh twenty-three thousand four hundred and fifty-six”. This function, by default, converts the numbers in Indian currency format. The formula used here is: =NUMBERTEXT(A1)

If you want to display the numbers in USD currency format, then use “en” as the second string. This will convert “123456” to ” one hundred and twenty-three thousand, four hundred and fifty-six”. The formula used here is: =NUMBERTEXT(A1; “en”).

Displaying Numbers To Words in Different Languages in OpenOffice Calc

Using the below-given code as a second string, you can display the number in words in 60 different languages. These codes can be used in both the NUMBERTEXT and MONEYTEXT functions.

Language Codes for NUMBERTEXT & MONEYTEXT

1. af – Africaans
2. bg – Bulgarian
3. ca – Catalan
4. cs – Czech
5. da – Danish
6. de – German
7. de-CH – Swiss Standard German orthography (dreissig instead of dreißig)
8. de-LI – Swiss Standard German orthography (dreissig instead of dreißig)
9. el – Greek
10. en – English (one hundred one)
11. en-AU – English (one hundred and one)
12. en-GB – English (one hundred and one)
13. en-IE – English (one hundred and one)
14. en-IN – English with Indian numbering system (lakh = 100.000, crore = 10^7)
15. en-NZ – English (one hundred and one)
16. eo – Esperanto
17. es – Spanish
18. et – Estonian
19. fi – Finnish
20. fr – French
21. fr-BE – Belgian French
22. fr-CH – Swiss French
23. ga – Irish
24. gl – Galician
25. he – Hebrew
26. hr – Croatian
27. hu – Hungarian
28. id – Indonesian
29. is – Icelandic
30. it – Italian
31. ja – Japanese
32. ko – Korean
33. ko-KR – Korean (South)
34. ko-KP – Korean (North)
35. lb – Luxembourgish
36. lg – Luganda
37. lt – Lithuanian
38. lv – Latvian
39. mr – Marathi
40. ms – Malaysian
41. mt – Maltese
42. nb – Norwegian Bokmål
43. nl – Dutch
44. nn – Norwegian Nynorsk
45. no – Norwegian (Bokmål)
46. pl – Polish
47. pt – Portuguese
48. pt-BR – Brazilian Portuguese
49. ro – Romanian
50. ru – Russian
51. sh – Serbian (Latin)
52. sl – Slovenian
53. sq – Albanian
54. sr – Serbian (Cyrillic)
55. sv – Swedish
56. th – Thai
57. tr – Turkish
58. uk – Ukrainian
59. vi – Vietnamese
60. zh – Chinese (simplified)

MONEYTEXT Function In OpenOffice Calc

You can use the MONEYTEXT Function to convert numbers to words in different currencies along with language options.

SYNTAX – MONEYTEXT

=MONEYTEXT(Cell Reference or Number; Currency)

OR

=MONEYTEXT(Cell Reference or Number, Currency; Language)

Use the strings in ” ” marks.

Using the MONEYTEXT Function in Calc

Let’s convert some numbers using this function with and without the language option.

“123456” converts to “one hundred and twenty-three thousand, four hundred and fifty-six U.S. dollars”. This function, by default, converts the numbers in Indian currency format. The formula used here is: =MONEYTEXT(A1; “USD”, “en”)

MONEYTEXT For Indian Rupees

If you want to display the numbers in Indian currency format, then use “INR” as the second string and “en-IN” as the third string. This will convert “123456” to ” one lakh twenty-three thousand four hundred and fifty-six Indian rupees”. The formula used here is: =MONEYTEXT(A1; “INR”; “en-IN”)

You can also check the SpellNumber Indian Rupees Function in Google Sheets.

The best part about this Function is that you don’t have to insert it in every new file. Once you install it, it will work with every file on your PC.

Frequently Asked Questions

If you like this article, kindly share it on different social media platforms so that your friends and colleagues can also benefit from the same. Sharing is Caring.