Posts

Showing posts from December, 2016

MS Excel Currency converter VBA code

To convert numbers into text, there is no  builtin function in MS Excel as of now. Using the below VBA code you can overcome this issue. There are situations like writing a cheque leaf, printing a rent agreement, or writing contract documents that may require printing the transaction amount in the text. Make use of this code to convert numbers into text automatically.  Copy and paste this VBA code into your Excel VBA editor module. Or Insert an empty module and paste this code. Attribute VB_Name = "Module1" 'Attribute VB_Name = "Module2" ' ****  Author          : Krishna S ' ****  Tittle          : Converting Hindu Arabic Currency(Indian System) to Words ' ****  Copyright Owner : Krishna S ' ****  Description     : This utility converts currencies in Indian numbering system to words. ' ****  Limitations     : Converts only upto 10,00,00,000( Ten Crores) Function C...