How to Convert Excel 2007 Number to Text

Read iSecrets.
New magazine about gadgets and mobile technology.
http://app.appsflyer.com/id946420218?...

Learn how to convert numbers into text in Microsoft Excel

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
https://itunes.apple.com/ru/app/howte... - 4000 FREE TUTORIALS on your iPhone!
https://play.google.com/store/apps/de... - 4000 FREE TUTORIALS on your Android phone!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+

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".

In the following window select the code of the function called "SpellNumber" and copy it.

Then go back to your excel document. Go to "Developer" tab and click "Visual Basic".

In the appeared Visual Basic window, go to the "Insert" tab and choose "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.

---

Closed Caption:

in this video tutorial will show you how
to convert an Excel number to text in
order to convert an Excel number to text
open your Excel document
then open a web browser
in the address bar type spell number
from the search results choose the link
how to convert a numeric value into
english words in Excel
in the following window select the code
of the function cold spell number and
copy it
then go back to your Excel document
go to the Developer tab and click visual
basic
in the appearance visual basic window go
to the insert tab and choose module
based the copied code
then go to the file tab and choose
clothes and return to Microsoft Excel
now type the equal spell number 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 drag it down