How can I get currency amounts to display in word-form using the Indian Numbering System (e.g., "lakh")? [closed]
In Calc, when i use =moneytext()
to calculate currency number to word, like 123 means One Hundred and Twenty Three its work properly, But when the currency number 423977 in the word shows "four hundred and twenty-three thousand, nine hundred and seventy-seven" But i want to show Four Lakh Twenty Three Thousand Nine Hundred and Seventy Seven
Please any one help me in this regard...