how can I convert numeric number into text
 

I want to convert numeric number into test,
for example
I want to convert no. "1" into "one" "2" into "two" etc.

firas, 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


"firas" wrote in message
...
I want to convert numeric number into test,
for example
I want to convert no. "1" into "one" "2" into "two" etc.