LIVE GST Certification Course by CA Arun Chhajer begins 21st April. Register Now!!

numeric digit into words

ARCHANA SAINI (Chartered Accountant) (163 Points)

17 June 2007

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

Reply
Follow
Share

23 Replies

(Guest)

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)
Replied 17 June 2007

ru there archana

chakri.aicwai (CMA) (49 Points)
Replied 18 June 2007

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

(Guest)

hi, ys say. i m here

(Guest)

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)

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

ARCHANA SAINI (Chartered Accountant) (163 Points)
Replied 19 June 2007

hi.i tried spellnumber command but its showing error

ARCHANA SAINI (Chartered Accountant) (163 Points)
Replied 19 June 2007

hi.i tried spellnumber command but its showing error

Ca Sandeep Jain (CA) (13 Points)
Replied 19 June 2007

if u find solution to your problem let me mail

The One (379 Points)
Replied 20 June 2007

Hello all,

Here is a solution that I found -

WordNum Function

Jayant Shaligram (Service) (146 Points)
Replied 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)
Replied 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)
Replied 21 June 2007

That's Archana

The One (379 Points)
Replied 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.