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.

Author: Mohammed Barakat

Mohammed Barakat is an Excellence Enabler, a Data Scientist, and a Trainer who holds several certifications. He is a Consultant Engineer in Industrial Engineering (JCE), a Project and Risk Management Professional (PMP, PMI-RMP), and a Six Sigma Black Belt (CSSBB). He is a proficient trainer accredited by Microsoft (MCT) and is also a speaker in national and international professional and business gatherings. He was named a winner of the prestigious ASQ MEA Quality Professionals Award for the year 2018 in Jordan.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.