Prev: Copy IF criteria met
Next: IF, THEN HELP
From: Jordan on 29 Apr 2010 12:39
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
From: Tom Hutchins on 29 Apr 2010 12:50
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
From: Eduardo on 29 Apr 2010 12:52
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
From: Jordan on 29 Apr 2010 16:56
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
From: Gord Dibben on 30 Apr 2010 10:08
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
<Jordan(a)discussions.microsoft.com> 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

 | 
Pages: 1
Prev: Copy IF criteria met
Next: IF, THEN HELP