| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a $figure be converted to words in another cell
Looking for a way to feed a $ amount from one cell to a different cell and
have it displayed as the dollar wording. i.e. $124.24 to One hundred twenty four dollars and 24/100. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a $figure be converted to words in another cell
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "sbsrose" wrote in message ... Looking for a way to feed a $ amount from one cell to a different cell and have it displayed as the dollar wording. i.e. $124.24 to One hundred twenty four dollars and 24/100. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a $figure be converted to words in another cell
The attached link has VBA code which might help http://www.ozgrid.com/VBA/ValueToWords.htm VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=568851 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| How Do? Take two words in cell 1 and slpit them to cell 2 & 3 | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
