Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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" |
#2
|
|||
|
|||
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" |
#3
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert currency to text | Excel Discussion (Misc queries) | |||
Formatting a text box to display as currency | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Text in cell not showing in full | Excel Discussion (Misc queries) |