A formula? No.
A User Defined Function? Yes
One of these links can probably help:
Code to convert numbers to words
********************************
http://www.barasch.com/excel/numb2words.htm
http://support.microsoft.com/default...;EN-US;Q213360
http://www.exceltip.com/st/Formulas_... xcel/301.html
http://www.bygsoftware.com/examples/examples.htm
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
Regards,
Ron
"jwduthler" wrote:
is there a formula that will take a number out of a cell, and put the same
info in another cell writen in full english. Kind of what you would use for
a cheque
ie
a1= $25.32
destination cell = "Twenty Five Dollars and Thirty Two Cents"