Ask Your Question
0

How can I get currency amounts to display in word-form using the Indian Numbering System (e.g., "lakh")? [closed]

asked 2014-08-13 18:20:08 +0200

GOLAM007 gravatar image

updated 2014-08-18 07:23:44 +0200

oweng gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-02 12:22:45.264335

2 Answers

Sort by » oldest newest most voted
1

answered 2014-08-13 18:32:54 +0200

karolus gravatar image

Maybe

=SUBSTITUTE(MONEYTEXT(423977);"hundred";"Lakh")
?
Karolus

edit flag offensive delete link more
1

answered 2014-08-18 07:14:14 +0200

oweng gravatar image

updated 2014-08-18 07:22:43 +0200

As @karolus has indicated, your question does not indicate correct use of the MONEYTEXT function in the NumberText extension. To obtain a number (in cell A1) in Indian rupees requires =MONEYTEXT(A1;"INR"). Please refer this answer for further details.

Having said that, it appears there is no support in the NUMBERTEXT function for the Indian Numbering System. There may not even be any support for this numbering system in Calc or LO as a whole. There is currently no open (or closed) bug relating to this issue.

Please file an enhancement bug and provide as much information about this new feature as possible. Don't forget to mark your bug as an 'enhancement'. The QA team will be happy to help you triage your feature request in the bugtracker. Please post a link to any bugs you file in a comment below using the format "fdo#123456". Thanks.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-08-13 18:20:08 +0200

Seen: 654 times

Last updated: Aug 18 '14