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 +0100

GOLAM007
11 ●2 ●2 ●3

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

23253 ●20 ●98 ●167

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

add a comment

1

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

karolus

5534 ●17 ●40

Maybe

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

edit flag offensive delete link

add a comment

1

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

oweng

23253 ●20 ●98 ●167

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

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

add a comment

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

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

Question Tools

Stats

Related questions

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

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

Question Tools

Stats

Related questions

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

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