See
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
"news" wrote in message
...
From the cells B2 to B18 I have some values in USD.
In B19 the sum of B2 to B18 is there. ( for example $ 1250.85)
Now In the cell B21 I need the wording corresponding to the figure found
in
B19 (Example: USD. One Thousand Two Hundred and Cents Eighty Five only)
Can any one help me.
t.thirumurthi