How do I display numerals (5) as words (five)?

[Wesley Poston]

I need to display a series of numbers from a list (5, 10, 20) as words (five,
ten, twenty). Is there a format, formula or converter that does that?

 

[Bob Phillips]

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[bpeltzer]

Check http://support.microsoft.com/default.aspx?scid=kb;en-us;213360 (found
by searching microsoft.com for spellnumber)