Rupees -In Words Conversion - Excel Formula
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Forms, Formats & Questionnaires

Rupees -In Words Conversion - Excel Formula

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. Join us to learn and grow with your peers.
File Type: xls RupeeInWord.xls (32.5 KB, 8096 views)
File Type: xls RupeeInWord(Unprotected).xls (32.5 KB, 2234 views)
File Type: xls RupeeInWord(UnprotectedNew).xls (36.0 KB, 1222 views)
satee - Member Since: Jan 2010
Fine I can see conversion in attached file, but how do I write this formula in my Invoice?

psdhingra - Member Since: Aug 2009
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.

konada67 - Member Since: Jun 2010
Dear Mr. Das, Pl give the password of the file, so that the formula used can be shared. regards, K N RAO

Biplab Das - Member Since: Jul 2011
Thanks All of Viewers. Now You can use this with your utility... Hope it will works successfully !

pbskumar2006 - Member Since: Mar 2006
Dear Das ji, Its very amazing and nice but solution require to incorporate into other excel sheets. Regards, PBS KUMAR

psdhingra - Member Since: Aug 2009
Thanks Biplab. By attaching the formula sheet you have provided a great help to community.

hiyamedia - Member Since: Jul 2008
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. Join us to learn and grow with your peers.
File Type: zip smb.xla.zip (8.0 KB, 629 views)
Keshav Gupta - Member Since: Aug 2011
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

mantapurwar - Member Since: Aug 2011
Quote:
Originally Posted by Biplab Das View Post
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 ..... )
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 Page 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.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


4
LIKES

8939
VIEWS

26
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network