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..
27th August 2011 From India, Kolkata
Attached Files
Shared By Cite.Community Member "Biplab Das" For Public Download
File Type: xls RupeeInWord.xls (32.5 KB, 15562 views)
File Type: xls RupeeInWord(Unprotected).xls (32.5 KB, 3873 views)
File Type: xls RupeeInWord(UnprotectedNew).xls (36.0 KB, 2931 views)

satee 
Fine I can see conversion in attached file, but how do I write this formula in my Invoice?
27th August 2011 From India, Mumbai
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.

SO, BETTER GIVE THE EXCEL FORMULA TO PROVIDE REAL HELP TO MEMBERS.
28th August 2011 From India, Delhi
Dear Mr. Das, Pl give the password of the file, so that the formula used can be shared. regards, K N RAO
28th August 2011 From India, Secunderabad
Thanks All of Viewers. Now You can use this with your utility... Hope it will works successfully !
28th August 2011 From India, Kolkata
Dear Das ji, Its very amazing and nice but solution require to incorporate into other excel sheets. Regards, PBS KUMAR
29th August 2011 From India, Kakinada
Thanks Biplab. By attaching the formula sheet you have provided a great help to community.
29th August 2011 From India, Delhi
Good effort Das! but I still prefer the Add-in that puts all formulae in the VB Script and use it wherever needed.
29th August 2011 From India, Mumbai
Attached Files
Shared By Cite.Community Member "hiyamedia" For Public Download
File Type: zip smb.xla.zip (8.0 KB, 1325 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
29th August 2011 From India, Shimla
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.
29th August 2011 From India, Amravati





 
 
 
 







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+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network