How to Convert Numbers into Words in MS Excel



Guide

  1. Go to Microsoft 365 and scroll down to find the prebuilt macro function provided by Microsoft.

  2. Copy the code to your clipboard for later use.

  3. Go to your Excel and click File.

  4. Go to the Option tab.

  5. Go to Customize Ribbon, check Developer, and click OK.

  6. In the VBA editor, click Insert > Module to open a blank code window.

  7. Paste the copied code into the VBA editor, press Ctrl + S to save, and close the editor.

  8. In a blank cell, type: =NumberText(A2) (replace A2 with the cell holding the number), and then Enter.

  9. Now, numbers in the selected cells will be converted to their word equivalents.

  10. Drag the formula down or across the cells to apply it, converting numbers to text in each selected cell.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline