Change "1,2,3..." to "one,two,three..."
 

How can I change "1,2,3..." to "one,two,three..." in Excel? Using Format or
does excel got this function build in? Thank you!

No built-in. At http://www.xldynamic.com/source/xld.xlFAQ0004.html there are
some examples of converting numbers to words, but they tend to be for
monetary amounts, so you will probably need to call it a number of times and
concatenate the results.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"q0_0p" wrote in message
...
How can I change "1,2,3..." to "one,two,three..." in Excel? Using Format
or
does excel got this function build in? Thank you!

See:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
How can I change "1,2,3..." to "one,two,three..." in
Excel? Using Format or
does excel got this function build in? Thank you!
.

This link is useful and thx Bob Phillips and Jason Morin.

"Jason Morin" wrote:

See:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
How can I change "1,2,3..." to "one,two,three..." in
Excel? Using Format or
does excel got this function build in? Thank you!
.