Dear All,
As per the requirement from all of you, I am attaching this file because it is not possible for me to reply to all of you. Please download the attached file for your own use.
Thanks,
Pawan Kumar
HRD
From India, Delhi
Acknowledge(0)
Amend(0)
2As per the requirement from all of you, I am attaching this file because it is not possible for me to reply to all of you. Please download the attached file for your own use.
Thanks,
Pawan Kumar
HRD
From India, Delhi
Acknowledge(0)Amend(0)
Press ALT+F11 on Excel then goto Modules below on left and paste the notepad text attached here. then in formula for cell type =ntow(cellreferance) [e.g. =ntow(A2) or = ntow(4168 ). Thats it.
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Pawan,
Good work. I have an easy method of using this file. Here it goes:
1. Save the file on the desktop.
2. From your Excel, go to Tools -> Options -> Add-ins.
3. Select Browse. Now you will be directly taken to the Add-ins folder.
4. Here, paste the file you saved.
5. Now this add-in is automatically selected by Excel. If not, please check the box for the add-in "Rswords."
6. Now, you can easily use the formula in any Excel worksheet by just entering the formula "=rswords(cell reference or value)."
Note: This works only on machines where you have this add-in. So please ensure that before sending the file saved on your computer with this formula to another machine, that machine also has it. Otherwise, the result on the other computer will not be displayed.
Thanks, Pawan, for the file.
Regards,
From India, Hyderabad
Acknowledge(0)Amend(0)
Good work. I have an easy method of using this file. Here it goes:
1. Save the file on the desktop.
2. From your Excel, go to Tools -> Options -> Add-ins.
3. Select Browse. Now you will be directly taken to the Add-ins folder.
4. Here, paste the file you saved.
5. Now this add-in is automatically selected by Excel. If not, please check the box for the add-in "Rswords."
6. Now, you can easily use the formula in any Excel worksheet by just entering the formula "=rswords(cell reference or value)."
Note: This works only on machines where you have this add-in. So please ensure that before sending the file saved on your computer with this formula to another machine, that machine also has it. Otherwise, the result on the other computer will not be displayed.
Thanks, Pawan, for the file.
Regards,
From India, Hyderabad
Acknowledge(0)Amend(0)
Nice effort by Pawan. Guys, I know of an add-in tool I have been using for more than 2 years. It is very useful as it has automated many features, including ones provided by Pawan, and besides, it is free. It only asks you to donate some money to their site if you find it useful.
[Free Microsoft Excel add-in download - Excel spreadsheet free downloads and Excel VBA tools](http://www.excel-extools.com/)
Acknowledge(0)Amend(0)
[Free Microsoft Excel add-in download - Excel spreadsheet free downloads and Excel VBA tools](http://www.excel-extools.com/)
Acknowledge(0)Amend(0)
its in the google its self, if you type suresh addin you can able to download the excel software and then you can add in in the excel in yopur desktop.Thanks & RegardsParthasarathy
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Hi, Really Good One.... thnx for sharing..... I have saved an excel file with Password Secuirty... I forgot the password..... If possible plz help how to break password... Regards Imee
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
dear pawan, just i gone to the excel and also seen in the user defined of the function... there is no formula named rsword.. can you tell me on what version of excel is it available.
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Hi all,
Just try this; I think it's something easy. Simply open any Excel sheet and enter any number, such as 50, 60, 70, etc., in one cell. Then, in the next cell, use the following formula: =RsWords(select any cell) and press enter.
=RsWords(F2)
This should help you accomplish the task easily.
From United States, Palo Alto
Acknowledge(0)Amend(0)
Just try this; I think it's something easy. Simply open any Excel sheet and enter any number, such as 50, 60, 70, etc., in one cell. Then, in the next cell, use the following formula: =RsWords(select any cell) and press enter.
=RsWords(F2)
This should help you accomplish the task easily.
From United States, Palo Alto
Acknowledge(0)Amend(0)
Hi guys, if I use this amount = rswords(22136.2), this is how it's coming out. "Hundred and" is not appearing. Please help me out or change the macro code.
Rupees Twenty Two Thousand One Hundred Thirty Six And Paise Twenty Only
From India, Madras
Acknowledge(0)Amend(0)
Rupees Twenty Two Thousand One Hundred Thirty Six And Paise Twenty Only
From India, Madras
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.