Save Rs 499 on a 2-Year Ad-Free CAclubindia Pro Membership. Subscribe Now!

numeric digit into words

Excel for Finance 4826 views 23 replies

ARCHANA SAINI

Chartered Accountant

163 Points Posted on 17 June 2007

hi, can anyone tell me in excel how can i convert numeric digit into words by using a formulae

Replies (23)

Guest

460605 Points Posted on 17 June 2007

Hi Check out this link /files_display_member.asp?member_id=21453 It contains files submitted by our fellow member Yatin . Regards Raju

gopal

student

21 Points Posted on 17 June 2007

ru there archana

chakri.aicwai

CMA

49 Points Posted on 18 June 2007

I HAVE A SOLUTION TO THIS PROBLEM.JUST MAIL TO GET THE NUMBER TO WORDS IN EXCEL CONVERSION TOOL

Guest

460605 Points Posted on 19 June 2007

hi, ys say. i m here

Yes I have downloaded an excel file with modifications for indian rupees you just have to mention the formula for the cell. if g5 = 1234 eg. spellnumber(g5) It will say Rupees One Thousand Two Hundred Thirty Four Only You can modify it to remove Rupees and paise too.

Guest

460605 Points Posted on 19 June 2007

email me you id at vijay at indiun dot net or vijay at careersearch dot org

ARCHANA SAINI

Chartered Accountant

163 Points Posted on 19 June 2007

hi.i tried spellnumber command but its showing error

ARCHANA SAINI

Chartered Accountant

163 Points Posted on 19 June 2007

hi.i tried spellnumber command but its showing error

Ca Sandeep Jain

13 Points Posted on 19 June 2007

if u find solution to your problem let me mail

The One

379 Points Posted on 20 June 2007

Hello all,

Here is a solution that I found -

WordNum Function

Jayant Shaligram

Service

146 Points Posted on 21 June 2007

Don't go for all these stuff and get yourself confused. The message posted by one of the guest within one hr of your message tells it all. A zip file containing an add in and how to install the add in is there on the given address. Just down load and start working. I have installed this and it works fine.

The One

379 Points Posted on 21 June 2007

Hi Jayant who is getting confused may I know? All solutions are welcome especially when all of them work - Archana is unable to use the spellnumber function since that is not configured on her MS Office - if you want the macro containing that please click here - Spellnumber Function

Jayant Shaligram

Service

146 Points Posted on 21 June 2007

That's Archana

The One

379 Points Posted on 21 June 2007

Ok, Let me see if I can explain this 1. Open Excel 2. Press Alt+F11 3. Click on Insert - Module 4. Now copy paste the module from the respective website (Use Word Num it works for sure) 5. Dont close any windows just for the time being 6. Go back to excel 7. From Insert - Function - Userdefined Function - select WordNum 8. Enter your number in my number Its a bit of a chore but it does work.