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

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

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