NUMBERTEXT

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. In other words, you can convert a numeric value into words using this function.

Similar to Excel, OpenOffice Calc doesn’t have any in-built 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 the numbers to words with a given currency.

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

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

  1. Click on the NUMBERTEXT extension page.
    NUMBERTEXT
  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 NUMBERTEXT Function?

NUMBERTEXT not only converts the numbers to words in English but also in many other different 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 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)

NUMBERTEXT

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

NUMBERTEXT

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 sued in both NUMBERTEXT and MONEYTEXT Function.

Languages Code 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 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”)

NUMBERTEXT

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

NUMBERTEXT

You can also check SpellNumber Indian Rupees Function In Google Sheets.

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

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.

If you have any queries or suggestions please share them in the comment section below. We will be more than happy to assist you.

%d bloggers like this: