| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change number to word | Excel Worksheet Functions | |||
| How do you merge a dollar amount into a word doc and keep the $? | Excel Worksheet Functions | |||
| How can I connect a word of text to a certain dollar value? | Excel Worksheet Functions | |||
| copy a number typed in a cell to another & change it to word form. | Excel Discussion (Misc queries) | |||
| change a number (100) to word (i.e Hundred) | Excel Discussion (Misc queries) | |||
Linear Mode
