How to Convert Number to Words in Excel?

no to Words in excel

Learn how to convert number to words in Excel with our step-by-step guide! In this video, we’ll show you a secret method to transform your numeric data into text effortlessly. This technique is perfect for anyone looking to enhance their Excel skills, whether you’re a beginner or an advanced user. You’ll discover a simple formula that can save you time and make your spreadsheets more readable. Don’t miss out on this game-changing Excel hack! Watch now and master this essential skill.

By the end of this video, you’ll have a comprehensive understanding of how to convert numbers to words in Excel. We also provide tips and tricks to ensure you get the best results every time. Subscribe to our channel for more amazing Excel tutorials and tips. Hit the bell icon to stay updated with our latest videos. Leave a comment if you have any questions or need further assistance. Let’s get started!

Step-by-Step Guide

  1. Open Excel and Enable Developer Tab:
    • Go to File > Options.
    • In the Excel Options window, select Customize Ribbon.
    • Check the Developer option on the right pane to enable the Developer tab.
  2. Open the VBA Editor:
    • Click on the Developer tab.
    • Select Visual Basic to open the VBA editor.
  3. Insert a New Module:
    • In the VBA editor, go to Insert > Module. This will create a new module where you can write your custom function.
  4. Copy and Paste the VBA Code:
    • Copy the following VBA code and paste it into the module:


5. Close the VBA Editor:

Close the VBA editor by clicking the X in the top-right corner or by going to File > Close and Return to Microsoft Excel.

6. Use the Custom Function in Excel:

Now you can use the NumberToWords function in your Excel worksheet.

For example, if you want to convert the number in cell A1 to words, you can type the following formula in another cell:


This custom function will convert the number in cell A1 to its corresponding word representation. For example, if A1 contains 123, the function will return “One Hundred Twenty Three”. If A1 contains 123.45, it will return “One Hundred Twenty-Three and 45/100”.


You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *