Change Currency In Word Form - Xls Download

Dear friends, Add currency value in colour cell then you can get its word(text) form. Enjoy it. JITENDRA PATEL
19th January 2011 From India, Mahesana

Attached Files (Download Requires Membership)

Change Currency in word.xls (33.0 KB, 3440 views)

Dear Jitendrabhai,
This is really good.
Can you help me to set the same formula for my Excel sheets where I have to prepare the Salary Slips every month & need to mention the Rupees in Words.
Currently I use the Inword application, but the application slows down my all excel files.
This formula would be really helpful, if I can get it on my salary file & can stop using the inword application.
Thanks.
20th January 2011 From India, Mumbai

the file is good, but when i try the same formula in a new worksheet it dose not work, can u explain this. i have changed the macro setting also to medium, but the result is nil. i dont get what the result come converting it into word form.
20th January 2011 From India, Vapi

Tks for this post. Can you help me to set the same formula for my Excel sheets where I have to prepare the Salary Slips every month & need to mention the Rupees in Words.
20th January 2011 From Vietnam, Hanoi

Dear All,

I think it will be helpful for all of you.

To enter a custom function into a worksheet, you can use Paste Function in Excel 2000, or you can use Insert Function in Excel 2002 and in Excel 2003. Excel 2000

To use Paste Function, follow these steps:

1. Select the cell that you want.
2. Click Paste Function on the Standard toolbar.
3. Under Function category, click User Defined.
4. Under Function name, click SpellNumber, and then click OK.
5. Enter the number or cell reference that you want, and then click OK.

Excel 2002 and Excel 2003

To use Insert Function, follow these steps:

1. Select the cell that you want.
2. Click Insert Function on the Standard toolbar.
3. Under Or select a category, click User Defined.
4. In the Select a function list, click SpellNumber, and then click OK.
5. Enter the number or cell reference that you want, and then click OK.

you have to put the resulted formula in the next column of numeric value i.e. column b4 value is 35
paste the resulted formula in c4 .

best regards,
Niranjan
21st January 2011 From India, New Delhi

Dear sir, thanx for this good & useful knowledge but i also want to know abt it to apply in excel thanx
21st January 2011 From India, Gurgaon

Dear Jitendra The formula you have given is not working in Windows 2007. Can you throw some light With warm regards S. Bhaskar
21st January 2011 From India, Kumbakonam

Dear all,
Try this function.
You need to open VB - insert module and paste this function and save.
Then save the worksheet in a macro enabled format and everytime you open this sheet you can use this function.
Its 'spellcurr"
To use type =spellcurr(reference cell)
Hope same is usefull.
21st January 2011 From India, Pune

OK the extension of Office 2007 - .docx was not working here is the file in office 2003
21st January 2011 From India, Pune

Attached Files (Download Requires Membership)

Function SpellCurr.doc (39.0 KB, 210 views)

Dear Jitendrabhai, This is really very nice and good. Can you help me to set the same formula for my Excel sheets deferent currency. Regards Qurbanul haq
21st January 2011 From United Arab Emirates, Dubai