Value to text words conversion
 

I am preparing a mail merge document and have to include
both the numerical value ($5,318.27) and the word text
(Five Thousand Three Hundred Eighteen Dollars and 27
cents) in the body. This is similar to the way a check is
written, but it not a check. What is the simplest way to
change the value to the word text?

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

--

HTH

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


"Fred Butterfield" wrote in message
...
I am preparing a mail merge document and have to include
both the numerical value ($5,318.27) and the word text
(Five Thousand Three Hundred Eighteen Dollars and 27
cents) in the body. This is similar to the way a check is
written, but it not a check. What is the simplest way to
change the value to the word text?