![]() This will convert “123456” to ” one hundred and twenty-three thousand, four hundred and fifty-six”. If you want to display the numbers in USD currency format, then use “en” as the second string. “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) Let’s convert some numbers using this function with and without the language option. NUMBERTEXT supports around 60 languages in which you can convert numbers to words. Just by using the number string, it will convert the number to words. To use this function you need either one string or two strings. =NUMBERTEXT(Cell Reference or Number, Language) OpenOffice has created and published this extension on their website. There is no direct function in OpenOffice to perform the above action. 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”. Your NUMBERTEXT and MONEYTEXT Extension is ready to use. Download the extension from the green download button.Click on the NUMBERTEXT extension page. ![]() Install NUMERTEXT add-in in OpenOffice Calc in 3 Easy Steps ![]() Languages Code for NUMBERTEXT & MONEYTEXT.Displaying Numbers To Words in Different Languages in OpenOffice Calc.Install NUMERTEXT add-in in OpenOffice Calc in 3 Easy Steps.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |