If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format a dollar amount to text
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 |
#2
|
|||
|
|||
Format a dollar amount to text
Debra Dalgleish discusses several means to do this on her Contextures site:
http://www.xldynamic.com/source/xld.xlFAQ0004.html Hope this heklps, Hutch "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 |
#3
|
|||
|
|||
Format a dollar amount to text
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 |
#4
|
|||
|
|||
Format a dollar amount to text
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|