Convert numbers into words

Thanks a lot, very use ful indeed

Thank U very much.

i am not getting addin IMword in formatting toolbar..

pls help

Feeling pleased to see u all reply

Regards

Rangarajan.K

kindly provide the formula of convert number into word in excel

iam very thanful for this act.

Run the attached addin in your excel.

Open excel write any number in a cell   -> go to another cell
-> write there =rswords(select the cell in which u hav placed the number)
-> press enter.

I hope u will surely b benefitted.

cvvb

I have been using the addin inword.xla for a long time and it was very useful. However, the drawbacks are that when you send data in excel file containing an inword formula, the recipient also needs to have the inword addin otherwise it shows error. Also it did not add the word"Rupee" in prefix and "Paise" in suffix which is the Indian style of writing.

But I now found something better. This is a Program by

'**** Yogi Anand -- ANAND Enterprises -- Rochester Hills MI 48309 -- 248-375-5710 www.anandent.com
'**** Last updated 03-Oct-2003
'**** SpellIndian (modified on 20-Sep-2003 to 1) show Rupees to precede, and to show "" for 0 paise)

I found a program written by Mr. Yogi Anand and I am using it now. A lot of people who do not know VBA find it a problem to use it, so I have compiled it in an excel sheet and attached the same. The original function was titled spellindian, which I found was too long so I changed the name of the routine to "Rupee".

Just download the excel file and start working. It is as simple. If you know VBA then the routine is anyway available insid ethe file and you can always copy it to your excel sheet.

If you already have an excel sheet where you want to use the formula, then do the following:

1. open the attached file 

2. Copy and paste all the sheets from your excel file into the attached file.

3. Save it back in the name you want.

Even if you send the excel file to someone it will still work. If you are working in excel 2010, then just rename the same in the new format as a macro enabled worksheet and it will work.

I hope you find this useful.

If you pass it on to others, just acknowledge the original author as a matter of courtesy.

Regards

raju krishnan

I Am so gladful to know the function. And i am also successful as per your instruction. But i thing i wnat to know. My problem is as follwos:

If i enter a number in a cell(Cell no. A1). Than the number would be convered to word in another cell (Cell No. B1).

Is it possible? Please help me.

Regards,

Asit Poddar.

(Accountant)

thank you . it will help me a lot