Is there a formula to change number to word. Ex. $10 > ten dollar

  • Thread starter Thread starter Nick D
  • Start date Start date
N

Nick D

More specifically, I want to enter a dollar amount and in another cell have
it write out the amount (like on a check).

Cell a1 - $10.24

Cell a2 - Ten dollars and 24/100
 
hi
formulas return values to the cell in which they ocupy. they can not perform
action.
the request you have made would reguire some heavy duty code.
see these sites for samples.
http://support.microsoft.com/?kbid=213360
http://www.ozgrid.com/VBA/ValueToWords.htm
http://www.sulprobil.com/html/spellnumber.html
http://www.xldynamic.com/source/xld.xlFAQ0004.html

i don't think any of them cover dollar amounts. just to let you know what
you are up against. best advice...start coding or give it up.

regards
FSt1
 
Back
Top