How to Convert Numbers into Words in MS Excel
Here's how to do it:
- Go to Microsoft 365 and scroll down to find the prebuilt macro function provided by Microsoft.
- Copy the code to your clipboard for later use.
- Go to your Excel and click File.
- Go to the Option tab.
- Go to Customize Ribbon, check Developer, and click OK.
- In the Developer tab, click Visual Basic or press Alt + F11.
- In the VBA editor, click Insert > Module to open a blank code window.
- Paste the copied code into the VBA editor, press Ctrl + S to save, and close the editor.
- In a blank cell, type: =NumberText(A2) (replace A2 with the cell holding the number), and then Enter.
- Now, numbers in the selected cells will be converted to their word equivalents.
- Drag the formula down or across the cells to apply it, converting numbers to text in each selected cell.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it