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

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?

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

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Wesley Poston" <Wesley wrote in message
...
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?

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

Check http://support.microsoft.com/default...b;en-us;213360 (found
by searching microsoft.com for spellnumber)

"Wesley Poston" wrote:

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?