Converting Currency figures to Text
I am designing invoice format for my business. I would like to convert the grand total amount in figures (in Indian Rupees) to Text and display the same in a predetermined cell automatically. For ex: Rs. 2,20,200.25 should be converted to "Rupees Two Lakhs Twenty Thousand Two Hundred and Paise Twenty Five Only." Is there any option in Excel 2007 to facilitate this, which I am unaware of? Can somebody enlighten me?
Hi Harivunnava, welcome to the forum.
There is nothing built into Excel that will do this. It would require a custom function or macro. An example of this (using dollars and cents) is here: http://www.ozgrid.com/VBA/CurrencyToWords.htm
There are other examples available if you search Google, but not sure if someone has designed one specifically for Indian currency as it appears to be a bit more complex (3 types instead of 2).
Possible add-in: http://www.dq.winsila.com/tips-trick...and-words.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks