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.
