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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mani K" <Mani wrote in message
...
\*CardText
Displays results as cardinal text. The result is formatted in lowercase
letters unless you add a format switch to specify a different
capitalization.
For example, { = SUM(A1:B2) \* CardText } displays "seven hundred ninety",
and { = SUM(A1:B2) \* CardText \* Caps } displays "Seven Hundred Ninety".
What is the similar syntax in Excel to display the sum in words?