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

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

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

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

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