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
Posted 8th November 2009 From India, Mumbai

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
Posted 9th November 2009 From India, Hyderabad
Hi Please find attachment. In case you don’t find it please mail me at mfuria@consultant.com
Posted 10th November 2009 From India, Mumbai
Attached Files
Shared By Cite.Community Member "mahendrafuria" For Public Download
File Type: zip NUM_2_TEXT_ADDINS.zip (8.1 KB, 15113 views)
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]

Posted 10th November 2009 From India, Delhi
Attached Files
Shared By Cite.Community Member "shiv.sharma" For Public Download
File Type: txt SPELLNUMBER.txt (5.9 KB, 11189 views)
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
Posted 10th November 2009 From India, Nasik
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.
Posted 10th November 2009 From India, Panipat
Mr Arnold, Please check the attached file for converting amount in numbers to words.
Posted 11th November 2009 From Saudi Arabia, Khobar
Attached Files
Shared By Cite.Community Member "Muneeb Akbar" For Public Download
File Type: xls Rupees convertor.xls (33.0 KB, 4983 views)
Dear Arnold, Please find the attached excel file for converting amount in numbers to amount in words. Regards, Muneeb Akbar
Posted 11th November 2009 From Saudi Arabia, Khobar
Attached Files
Shared By Cite.Community Member "Muneeb Akbar" For Public Download
File Type: xls Rupees convertor.xls (33.0 KB, 2021 views)
Hi Shiv Sharma, Thank you very much for the step by step details. This is the way we expect the details and I really appreciate your efforts. regards, raju thomas.
Posted 11th November 2009 From India, Bangalore
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]

Posted 16th June 2010 From India, Delhi
Attached Files
Shared By Cite.Community Member "shiv.sharma" For Public Download
File Type: txt SPELLNUMBER.txt (5.9 KB, 533 views)






 
 
 
 







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