Excel is a spreadsheet software developed by Microsoft that can save and analyze numerical data. Of the many purposes the program is used for, Excel is commonly used to organize monetary data. In doing so, cells can be formatted so that the figures are displayed in specific currencies. But further, a user-defined module can be created so that a function converts currencies into words. A module can be constructed by the user, but there are modules available on-line that create such function. Usually a single approach is used to create this function, and it is convenient for the user to copy and paste the ones available on-line.
Launch Microsoft Excel and open a spreadsheet.
Create a new module by pressing Alt+F11 and selecting “Module” under the “Insert” menu. A new window will appear.
Open a web browser and go to ozgrid.com/VBA/CurrencyToWords.htm.
Highlight and copy, by pressing Ctrl+C, the blue text that begins with “Function ConvertCurrency...” and ends with “End Function” near the very bottom of the web page.
Paste the copied text into the module window by pressing Ctrl+V. This will create a new function that you can now use in Excel.
Go to the cell that you wish to display currency in words.
Type in “=ConvertCurrencyToEnglish()” with the numerical value of the currency between the brackets. The currency will be converted to words. For instance, “=ConvertCurrencyToEnglish(12.30)” will display as “Twelve Dollars And Thirty Cents.”
