How to Convert Excel 2007 Number to Text

In this video tutorial we will show you how to convert excel number to text.



In order to convert number to text, open your excel document. Then open a web browser. Type “spellnumber”. In the results choose “How to convert a numeric value into English words in Excel”.
Choose the first result from the list

In the following window select the code of the function called “SpellNumber” and copy it.
Copy the code of function

Then go back to your excel document. Go to “Developer” tab and click “Visual Basic”.
Open the Visual Basic window

In the appeared Visual Basic window, go to the “Insert” tab and choose “Module”.
Open Module

“Paste” the copied code. Then go to “File” tab and choose “Close and Return to Microsoft Excel”.
Now, type “=spellnumber()” formula and see how number converts to text. To apply the same formula to other cells, left click on a cell with formula, hold it and drug it down.