CiteHR
Ξ ASK or SHARE
HOME ANSWERED NEW CONTACT ABOUT LOGIN
Home > Information Section > General Resources & Websites

Rupees Into Words - Visual Basic

arnolddominicmathias Started The Discussion:

Dear Members,

Can anybody provide me with some excel formulas or program to convert Rupees into words (in excel 2000)

If in my excel sheet I have the below mentioned numbers , then I should be able to convert them as mentioned below in the same excel sheet in the next column, by inserting some formula or by copy/ pasting from some program.

eg. 10200 = Rupees Ten thousand two hundred only
110200 =- Rupess One lac ten thousand two hundred only
10200.50 = Rupees Ten thousand two hundred and paise fifty only

Arnold

[ travi ]
Dear Arnold, Please find the attached Software for Numeric to Word converter. You have to add to Add ins and make use of it. Regards, T. RAVI

[ Uma_avs ] (Contributing Member)
Hi ravi, Even I need this converter formula. I am not able to open the attachment. Can you please resend the Software for Numeric to Word converter once again. Thx, Uma.

[ mahendrafuria ] (Contributing Member)
Hi Please find attachment. In case you don’t find it please mail me at mfuria@consultant.com


Attached FilesProvided by community member mahendrafuria. Join us to learn and grow with your peers.
File Type: zip NUM_2_TEXT_ADDINS.zip (8.1 KB, 1202 views)
[ trapti ] (Contributing Member)
Hi Ravi, Where is the attachment?? pls. send on my email id as well:charuhm@gmail.com Thanks Trapti.

Dear all,

1. Open the attached file into notepad.
2. Select All and copy into clipboard by bressing CTRL+A & CTRL+C.
3. Start Microsoft Excel or the Existing Excel File.
4. Press ALT+F11 to start the Visual Basic Editor.
5. On the Insert menu, click Module.
6. Paste the copied content by pressing CTRL+V
7. Press ALT+Q to close and return to Excel.
8. You have to unable macros to work the function properly.
9. If the macros are disabled then the function will not work.
10. Your Formula "SpellNumber()" is ready.

Regards

[SHIV SHARMA]


Attached FilesProvided by community member shiv.sharma. Join us to learn and grow with your peers.
File Type: txt SPELLNUMBER.txt (5.9 KB, 357 views)
[ Pravin11 ] (Contributing Member)
Dear Mahendrafuria,

You try to give some valuable information to other person,
But. a file of Excel given by you Can not acecsabel. so please give details process of
acess or activate this file with MS Excel. i.e. go though MS Excel Options,Add Ins.Browse file path. File Name etc. other wise its wastage of time of above so many peoples.
Thanks.
BR
Pravin11

[ aby_vas ] (Contributing Member)
Is not working with excel 2007. Giving error as undefined character and highlights a square in VB. Nice try to build such a good function.

Dear Ravi, I am not able to open the attachment. Please forward the same to my email id sakthivel.vadivel@gmail.com Regards, Sakthivel Vadivel

pls send me this attachment in simple wayon my mail ID poonam_yadav78@yahoo.com as i am unable to download it.

Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.


5188 views15 replies
Knowledgebase Categories

Popular Discussions


PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE

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

Community Support & Professional Insights. Login & Explore 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