Biplab Das Started The Discussion:
This Xls files convert digits of Rupees into words. Its very simple but effective. Hope it will helps for Rupees Conversion. Please give comments.

For the Interest of many People , I am attaching the unprotected files. Please give your valuable suggestion. ( It calculates below 99 Crores. But with some modification it will be calculate more than 99 Crores ..... )

All Minor Mistake was removed and Procedure to Set this conversion to your Xls Sheet is writiten in RupeeInWord(UnprotectedNew).xls . Please Download...... and share your comments..
Attached FilesProvided by community member Biplab Das. Register to join your network of peers.
File Type: xls RupeeInWord.xls (32.5 KB, 15447 views)
File Type: xls RupeeInWord(Unprotected).xls (32.5 KB, 3827 views)
File Type: xls RupeeInWord(UnprotectedNew).xls (36.0 KB, 2872 views)
Fine I can see conversion in attached file, but how do I write this formula in my Invoice?
Dear Biplab,

It is really nice, but, its utility lies only when some one is able to incorporate the real formula in the excel sheet in his own documents. It won't provide any help to the community members if they have to write maually the amount in words in their invoices, payrolls or reports.

Dear Mr. Das, Pl give the password of the file, so that the formula used can be shared. regards, K N RAO
Thanks All of Viewers. Now You can use this with your utility... Hope it will works successfully !
Dear Das ji, Its very amazing and nice but solution require to incorporate into other excel sheets. Regards, PBS KUMAR
Thanks Biplab. By attaching the formula sheet you have provided a great help to community.
Good effort Das! but I still prefer the Add-in that puts all formulae in the VB Script and use it wherever needed.
Attached FilesProvided by community member hiyamedia. Register to join your network of peers.
File Type: zip (8.0 KB, 1306 views)
Dear Mr. Das

It is really a good one for conversion of numbers into words. Thanks for sharing the same with unprotected sheet. I have successfully converted my working sheet by using the various other formulas/links.

Thanks and regards

CS Keshav Lal Gupta
It is very usefull for me, I was trying to find information like this, I have done little modification in your formula by adding "ONLY" in the end of sentence.

Thank You, Very Much Mr. Das

Naresh H. Mantapurwar
Amravati dist. Amravati.


Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
Copyright 2016 Cite.Communities (CiteHR.Com) User contributions are owned by the contributor.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network