Most of Concerned using the Excel for their Account Matter. But it is not possible to Amount to In Words without any VB Code. Some where create the VB Code for Convert the Amount to In Words.
When we have to need the Amount Rs.500 to In Words, most of Excel User manually type as Five Hundred.
But if you have a unique Excel Tools and install in your Computer, the Amount will Convert to the In Words automatically as your required Cell.
For an example :- One Excel Sheet have 3 column with amount of each column and willing to Sum to the Next Cell, Just type " words" the Amount will be Convert automatically as the amount of Sum. Below the Picture what is the Excel tools activity
Installation Process this Excel Tolls :- FOR OFFICE 2003 USERS:-----
1) Unzip the file
2) Copy the In word Tools
3) Paste it in your any Drive
4) Open a new Excel Work Sheet
5) Click to Tools Menu > Choose Add Ins >Click Add Ins > Browse and select the In word Tools > OK ( Look below how to install in 2003)
FOR OFFICE 2007 USERS :- Open a New Work Sheet > Go to Open menu > Click the Excel Option>Select Add Ins > Browse the Excel Tool Menu ( where you paste Excel Tool) >Select > OK (Look the below given picture)
NOW CLOSE THIS EXCEL WORK SHEET OR BOOK AND RE-OPEN ANY EXCEL SHEET, PUT THE AMOUNT IN A-1 CELL > CLICK THE B1 CELL, PUT THE FORMULA =WORD(A1), CLICK ANY WHERE IN THIS WORK SHEET, LOOK THE B1 CELL
