| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a dollar amount to text
Place the code in your Personal.xls or a new workbook which you save as an
add-in. Load the add-in and it will remain in the background for use on all books and sheets. Gord Dibben MS Excel MVP On Thu, 29 Apr 2010 13:56:01 -0700, Jordan wrote: Thank you for the information. I was able to use it for the application I am working on. Do you know if there is a way to have this available for all worksheets in Excel? "Eduardo" wrote: Hi Jordan, look here http://www.xldynamic.com/source/xld.xlFAQ0004.html "Jordan" wrote: Is there a way to take $10.56 and format it to read Ten dollars and 56 cents. Thanks in advance for your help. Jordan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Yes or No Value if Dollar amount between two numbers | Excel Worksheet Functions | |||
| Comparing Row by Row - A-D dollar amounts to E dollar amount | Excel Worksheet Functions | |||
| How to use a name to represent a dollar amount | Excel Discussion (Misc queries) | |||
| multiply a text box on a report times a dollar amount | Excel Discussion (Misc queries) | |||
| Hide row if dollar amount is zero | Excel Discussion (Misc queries) | |||
Hybrid Mode
