What happened to the "NumToText" command in Excel?
 

How do you convert a number into an alphanumeric string.
i.e.
Convert "100" into "one hundred"

Gabriel, have a look here for a way to do it,

http://www.xldynamic.com/source/xld.xlFAQ0004.html


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Gabriel" wrote in message
...
How do you convert a number into an alphanumeric string.
i.e.
Convert "100" into "one hundred"