Converting Numbers to Words in Microsoft Office Excel

The process of converting numbers to words is indispensable in the finance/accounting sections of any organization. Yet, it is cumbersome and time-consuming especially when you have scores of transactions to finish in a limited time; e.g. multiple checks for vendors.

Although there is no built-in function to convert numbers to words in MS Excel, VBA (Visual Basic for Applications) in the backend of Excel provides the solution. The Excel file attached to this post, free for you to download and use, contains a VBA-customized function that translates any US Dollar amount to its equivalent wording.

Do you have a specific case you need to solve with MS Excel? Leave a reply to this post or send me a direct message.

PS: You may need to enable macros from the Macro Settings in the Trust Center of Excel so that the function works properly.

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply