Converts numbers into Word (Excel)


Support on Tally Excel Password Recovery etc.

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



Attached File : 25 in word.xls downloaded 9900 times

Total likes : 2 times

 
Reply   
 
Landmark Group

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

 
Reply   
 
Support on Tally Excel Password Recovery etc.

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



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

Total likes : 1 times

 
Reply   
 
Cost Accountant

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

 
Reply   
 
Professional

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



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

Total likes : 1 times

 
Reply   
 
Professional

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



Attached File : 32 xld spellnumber.xls downloaded 2570 times
 
Reply   
 
CS PURSUING

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

 
Reply   
 
Professional

Thanks Ramesh,

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

Kaushik



Attached File : 9 indianspellnoformula.zip downloaded 1760 times
 
Reply   
 
Support on Tally Excel Password Recovery etc.

The file posted by me does not contain any VBA.



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

Total likes : 1 times

 
Reply   
 
Officer Finance at JSW Energy Ltd

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.

 

Below is the procedure to use this formula.

 

 

Number (Cell A1)

9999

Text Formula

=num2text(A1)

Result

Rupees Nine  Thousand Nine hundred Ninety Nine Only

 

 



Attached File : 6 num2text.xla downloaded 5454 times

Total likes : 2 times

 
Reply   
 

LEAVE A REPLY

Your are not logged in . Please login to post replies

Click here to Login / Register  

 


×

  CCI MENU