Expert: Tom Ogilvy - 5/24/2008

Question
Hi!

i want to convert number into text
For example:

RS.2,30,000 into TWO LAC THIRTY THOUSAND ONLY

THANKS IN ADVANCE
HARDEEP KANWAR

Answer
Hardeep,
Based on your extremely poor and insulting rating, please do not come back to ask me any furthjer questions.  I am sorry I spent more than a half hour trying to give you a complete answer to your problem and sharing my knowledge. It is amazing how rude, disrepectful and unappreciative you are.

--
Regards,
Tom Ogilvy



There is no built in way to do that (no function provided in Excel for english or any other language except the Thailand Baht introduced in Excel 2002 as I recall).  You would have to write your own VBA code to do it or find someoneelse's  such as here:

http://www.ozgrid.com/VBA/ValueToWords.htm
You would need to modify it to handle lac's

Here is microsoft's code:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360
(think ozgrid ripped the off).   

http://support.microsoft.com/?kbid=95640
ACC: How to Convert Currency or Numbers into English Words

http://support.microsoft.com/?kbid=140704
XL: How to Convert a Numeric Value into English Words

Same limitation on lacs.


http://xcell05.free.fr/morefunc/english/index.htm
A free addin the has the NBTEXT function that does this in 13 languages, but unfortunately, it doesn't do Lac's  


This person has adapted VBA code to do Lac/Lachs:
http://answers.yahoo.com/question/index?qid=20071016005523AAlKbBa


Bob Phillips has put up a page on this topic although it isn't for LACs.  It has links to several other pages as well, one of which shows a formula approach to doing it (again, not for LACs)

http://www.xldynamic.com/source/xld.xlFAQ0004.html

-------------------
In a posting in the excel newsgroups, this person   said

Hi,


>FUNCTION(212546)="Two Lakh Twelve Thousand Five Hundred


Fourty Six"

E mail me, I have written one free add-ins to convert numbers into
Indian Rupees in Words and convert Number format(Positive Numbers) to
Indian Number System.


Regards,
Shah Shailesh
shahshaileshs@hotmail.com
---------------------------------------

Here is a link to many of the messages where this has been discussed in the Excel newsgroup:

http://groups.google.com/groups?as_q=convert+Lakh&num=10&scoring=r&hl=en&as_epq=...

or using tinyurl
http://tinyurl.com/3vfm7a

--
Regards,
Tom Ogilvy