Become a Govt. Certified GST Practitioner. Batch begins 18th Nov. Register Now!

Converts numbers into Word (Excel)

Manoj Garg (Support on Tally Excel Password Recovery etc.) (1987 Points)

11 May 2010

Use the sheet1 in the file where you want to convert numbers into words.

Reply
Follow
Share

14 Replies

CA CS CIMA Prakash Somani (Landmark Group) (23502 Points)
Replied 11 May 2010

Good one.. how did you do that ?? is there any macro used by you ?

Upgrade to CAclubindia Pro. Subscribe Now!

Manoj Garg (Support on Tally Excel Password Recovery etc.) (1987 Points)
Replied 11 May 2010

no, this is simple coding. want to see the codes. download the attached file.

Attached File : 22 in word unprotected .xls downloaded: 5395 times

1 Like

CMA.Baskar.V (Cost Accountant) (400 Points)
Replied 12 May 2010

Good and useful file.................

Kaushik (Professional) (549 Points)
Replied 13 May 2010

Attached another file without vba code to convert amount into words.

Attached File : 16 numstowords no vba.xls downloaded: 3070 times

1 Like

Kaushik (Professional) (549 Points)
Replied 13 May 2010

Attached another file without vba code to convert amount into words with different formula.

Attached File : 32 xld spellnumber.xls downloaded: 2783 times

Upgrade to CAclubindia Pro. Subscribe Now!

RAMESH KUMAR VERMA ( CS PURSUING ) (43853 Points)
Replied 13 May 2010

WOH ---------------------- ANOTHER HELPING TIPS FOR THE STUDENTS .

I WISH THAT "CA CLUB INDIA" WILL NEVER FORGET YOUR TIPS & HELPING ATTEMPT .

IN MY OPINION KAUSHIK JI, & MANOJI ARE HELPING ALL THE STUDENTS ,

THX

Kaushik (Professional) (549 Points)
Replied 13 May 2010

Thanks Ramesh,

Attached another file without vba code to convert amount into words with different formula for Indian Lakh Format by shailesh download from https://shahshaileshs.web.officelive.com/Misc.aspx.

Kaushik

Attached File : 9 indianspellnoformula.zip downloaded: 1990 times

Manoj Garg (Support on Tally Excel Password Recovery etc.) (1987 Points)
Replied 13 May 2010

The file posted by me does not contain any VBA.

Attached File : 50 in word unprotected .xls downloaded: 1840 times

1 Like

Radhe shyam (Officer Finance at JSW Energy Ltd) (50 Points)
Replied 27 May 2010

Hi,

Use attached formula to write a number into text.

For permanent installation follow these steps

In Excel 2003

Copy this file and

Go to Tools Menu

Click on Add-Ins

Click on Browse

And Paste this file in AddIns Folder and close it.

In Excel 2007

Got to Excel Option

Click on Add Ins

Click onManager Excel Add Ins (Go)

Click on Browse

And Paste this file in AddIns Folder and close it.