Most of Concerned have been used the Excel for their Account Matter. But it is not possible to Amount to In Words without any VB Code. Somewhere 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 the 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 has 3 column with the 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
1) Unzip the file
2) Copy the Sword 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
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
NOW CLOSE THIS EXCEL WORKSHEET 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 ANYWHERE IN THIS WORKSHEET, LOOK THE B1 CELL.
0 Comments