currency # to full text equivilant
 

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"

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"

Thanks anyways, the other post answered my question and it works great!!!!

"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"