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

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

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

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
"Nick D" wrote:

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

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

You will have to use VBA. Refer the belowlinks

http://www.ozgrid.com/VBA/ValueToWords.htm
http://support.microsoft.com/kb/213360
http://www.xldynamic.com/source/xld.xlFAQ0004.html


If this post helps click Yes
---------------
Jacob Skaria


"Nick D" wrote:

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