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

[q0_0p]

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!

 

[Bob Phillips]

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)

 

[Jason Morin]

See:

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

HTH
Jason
Atlanta, GA

 

[q0_0p]

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