convert currency to text

how to convert a currency number (for example $100) into a text representing
that number (one hundred dollars only)

http://support.microsoft.com/default...;EN-US;q213360

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Excel_Instructor" <Excel_Instructor@discussions.microsoft.com> wrote in
message news:8F661A1B-1204-415D-94A8-885B705FE7DA@microsoft.com...
> how to convert a currency number (for example $100) into a text
> representing
> that number (one hundred dollars only)

Thank you very much for the help you provided .. I really do appreciate it
Regards,
Tahani

"Niek Otten" wrote:

> http://support.microsoft.com/default...;EN-US;q213360
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "Excel_Instructor" <Excel_Instructor@discussions.microsoft.com> wrote in
> message news:8F661A1B-1204-415D-94A8-885B705FE7DA@microsoft.com...
> > how to convert a currency number (for example $100) into a text
> > representing
> > that number (one hundred dollars only)
>
>
>

i want to convert "1000" in text like "One Thousand" in excell by formula

is it possible

mahbub

"Tahani" wrote:

> Thank you very much for the help you provided .. I really do appreciate it
> Regards,
> Tahani
>
> "Niek Otten" wrote:
>
> > http://support.microsoft.com/default...;EN-US;q213360
> >
> > --
> >
> > Kind Regards,
> >
> > Niek Otten
> >
> > Microsoft MVP - Excel
> >
> > "Excel_Instructor" <Excel_Instructor@discussions.microsoft.com> wrote in
> > message news:8F661A1B-1204-415D-94A8-885B705FE7DA@microsoft.com...
> > > how to convert a currency number (for example $100) into a text
> > > representing
> > > that number (one hundred dollars only)
> >
> >
> >

mahbub

Yes it is possible.

Go to the website Nick provided below and see what is required.


Gord Dibben MS Excel MVP

On Tue, 13 Jun 2006 03:28:02 -0700, mahbub <mahbub@discussions.microsoft.com>
wrote:

>i want to convert "1000" in text like "One Thousand" in excell by formula
>
>is it possible
>
>mahbub
>
>"Tahani" wrote:
>
>> Thank you very much for the help you provided .. I really do appreciate it
>> Regards,
>> Tahani
>>
>> "Niek Otten" wrote:
>>
>> > http://support.microsoft.com/default...;EN-US;q213360
>> >
>> > --
>> >
>> > Kind Regards,
>> >
>> > Niek Otten
>> >
>> > Microsoft MVP - Excel
>> >
>> > "Excel_Instructor" <Excel_Instructor@discussions.microsoft.com> wrote in
>> > message news:8F661A1B-1204-415D-94A8-885B705FE7DA@microsoft.com...
>> > > how to convert a currency number (for example $100) into a text
>> > > representing
>> > > that number (one hundred dollars only)
>> >
>> >
>> >

Dear Gord Dibben

Thanks for ur quick response.

But i want a solution which i can apply in excel sheet. Nick's solution is
very long and i dont know how it apply in excel sheet.

if u have any solution regarding this just inform me

bye

"Gord Dibben" wrote:

> mahbub
>
> Yes it is possible.
>
> Go to the website Nick provided below and see what is required.
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 13 Jun 2006 03:28:02 -0700, mahbub <mahbub@discussions.microsoft.com>
> wrote:
>
> >i want to convert "1000" in text like "One Thousand" in excell by formula
> >
> >is it possible
> >
> >mahbub
> >
> >"Tahani" wrote:
> >
> >> Thank you very much for the help you provided .. I really do appreciate it
> >> Regards,
> >> Tahani
> >>
> >> "Niek Otten" wrote:
> >>
> >> > http://support.microsoft.com/default...;EN-US;q213360
> >> >
> >> > --
> >> >
> >> > Kind Regards,
> >> >
> >> > Niek Otten
> >> >
> >> > Microsoft MVP - Excel
> >> >
> >> > "Excel_Instructor" <Excel_Instructor@discussions.microsoft.com> wrote in
> >> > message news:8F661A1B-1204-415D-94A8-885B705FE7DA@microsoft.com...
> >> > > how to convert a currency number (for example $100) into a text
> >> > > representing
> >> > > that number (one hundred dollars only)
> >> >
> >> >
> >> >
>
>

There is no Excel Function that will convert numbers to text as you wish.

You must use a User Defined Function such as you find at the site Nick has
pointed to.

You copy the UDF to a general module in your workbook and it will show up in the
User Defined list under Function Wizard.

Couple of other sites can be found on Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0004.html

Note the Add-in by Laurent Longre.

It will add a function to Excel when loaded through Tools>Add-ins.


Gord

On Wed, 14 Jun 2006 00:23:02 -0700, mahbub <mahbub@discussions.microsoft.com>
wrote:

>Dear Gord Dibben
>
>Thanks for ur quick response.
>
>But i want a solution which i can apply in excel sheet. Nick's solution is
>very long and i dont know how it apply in excel sheet.
>
>if u have any solution regarding this just inform me
>
>bye
>
>"Gord Dibben" wrote:
>
>> mahbub
>>
>> Yes it is possible.
>>
>> Go to the website Nick provided below and see what is required.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Tue, 13 Jun 2006 03:28:02 -0700, mahbub <mahbub@discussions.microsoft.com>
>> wrote:
>>
>> >i want to convert "1000" in text like "One Thousand" in excell by formula
>> >
>> >is it possible
>> >
>> >mahbub
>> >
>> >"Tahani" wrote:
>> >
>> >> Thank you very much for the help you provided .. I really do appreciate it
>> >> Regards,
>> >> Tahani
>> >>
>> >> "Niek Otten" wrote:
>> >>
>> >> > http://support.microsoft.com/default...;EN-US;q213360
>> >> >
>> >> > --
>> >> >
>> >> > Kind Regards,
>> >> >
>> >> > Niek Otten
>> >> >
>> >> > Microsoft MVP - Excel
>> >> >
>> >> > "Excel_Instructor" <Excel_Instructor@discussions.microsoft.com> wrote in
>> >> > message news:8F661A1B-1204-415D-94A8-885B705FE7DA@microsoft.com...
>> >> > > how to convert a currency number (for example $100) into a text
>> >> > > representing
>> >> > > that number (one hundred dollars only)
>> >> >
>> >> >
>> >> >
>>
>>

thanks Dibben

im accounts person. pls. make me more clear how can i use.

im sorry for disturbing u.

but i need ur help

thanks

"Gord Dibben" wrote:

> There is no Excel Function that will convert numbers to text as you wish.
>
> You must use a User Defined Function such as you find at the site Nick has
> pointed to.
>
> You copy the UDF to a general module in your workbook and it will show up in the
> User Defined list under Function Wizard.
>
> Couple of other sites can be found on Bob Phillips' site.
>
> http://www.xldynamic.com/source/xld.xlFAQ0004.html
>
> Note the Add-in by Laurent Longre.
>
> It will add a function to Excel when loaded through Tools>Add-ins.
>
>
> Gord
>
> On Wed, 14 Jun 2006 00:23:02 -0700, mahbub <mahbub@discussions.microsoft.com>
> wrote:
>
> >Dear Gord Dibben
> >
> >Thanks for ur quick response.
> >
> >But i want a solution which i can apply in excel sheet. Nick's solution is
> >very long and i dont know how it apply in excel sheet.
> >
> >if u have any solution regarding this just inform me
> >
> >bye
> >
> >"Gord Dibben" wrote:
> >
> >> mahbub
> >>
> >> Yes it is possible.
> >>
> >> Go to the website Nick provided below and see what is required.
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >> On Tue, 13 Jun 2006 03:28:02 -0700, mahbub <mahbub@discussions.microsoft.com>
> >> wrote:
> >>
> >> >i want to convert "1000" in text like "One Thousand" in excell by formula
> >> >
> >> >is it possible
> >> >
> >> >mahbub
> >> >
> >> >"Tahani" wrote:
> >> >
> >> >> Thank you very much for the help you provided .. I really do appreciate it
> >> >> Regards,
> >> >> Tahani
> >> >>
> >> >> "Niek Otten" wrote:
> >> >>
> >> >> > http://support.microsoft.com/default...;EN-US;q213360
> >> >> >
> >> >> > --
> >> >> >
> >> >> > Kind Regards,
> >> >> >
> >> >> > Niek Otten
> >> >> >
> >> >> > Microsoft MVP - Excel
> >> >> >
> >> >> > "Excel_Instructor" <Excel_Instructor@discussions.microsoft.com> wrote in
> >> >> > message news:8F661A1B-1204-415D-94A8-885B705FE7DA@microsoft.com...
> >> >> > > how to convert a currency number (for example $100) into a text
> >> >> > > representing
> >> >> > > that number (one hundred dollars only)
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
>
>

The instructions given at

http://support.microsoft.com/default...;EN-US;q213360

are as clear and concise as any I could provide so I will leave you with that.

Exception: you can copy and paste the code rather than type it into a module.

Tell you what I can do.

I will create a workbook with the SpellNumber Function included and a couple of
examples of its use.

Send me personally to my email, your email address and a request to send you the
workbook.

Change the AT and DOT in my address to appropriate punctuation.


Gord Dibben MS Excel MVP


On Wed, 14 Jun 2006 22:54:01 -0700, mahbub <mahbub@discussions.microsoft.com>
wrote:

>thanks Dibben
>
>im accounts person. pls. make me more clear how can i use.
>
>im sorry for disturbing u.
>
>but i need ur help
>
>thanks
>
>"Gord Dibben" wrote:
>
>> There is no Excel Function that will convert numbers to text as you wish.
>>
>> You must use a User Defined Function such as you find at the site Nick has
>> pointed to.
>>
>> You copy the UDF to a general module in your workbook and it will show up in the
>> User Defined list under Function Wizard.
>>
>> Couple of other sites can be found on Bob Phillips' site.
>>
>> http://www.xldynamic.com/source/xld.xlFAQ0004.html
>>
>> Note the Add-in by Laurent Longre.
>>
>> It will add a function to Excel when loaded through Tools>Add-ins.
>>
>>
>> Gord
>>
>> On Wed, 14 Jun 2006 00:23:02 -0700, mahbub <mahbub@discussions.microsoft.com>
>> wrote:
>>
>> >Dear Gord Dibben
>> >
>> >Thanks for ur quick response.
>> >
>> >But i want a solution which i can apply in excel sheet. Nick's solution is
>> >very long and i dont know how it apply in excel sheet.
>> >
>> >if u have any solution regarding this just inform me
>> >
>> >bye
>> >
>> >"Gord Dibben" wrote:
>> >
>> >> mahbub
>> >>
>> >> Yes it is possible.
>> >>
>> >> Go to the website Nick provided below and see what is required.
>> >>
>> >>
>> >> Gord Dibben MS Excel MVP
>> >>
>> >> On Tue, 13 Jun 2006 03:28:02 -0700, mahbub <mahbub@discussions.microsoft.com>
>> >> wrote:
>> >>
>> >> >i want to convert "1000" in text like "One Thousand" in excell by formula
>> >> >
>> >> >is it possible
>> >> >
>> >> >mahbub
>> >> >
>> >> >"Tahani" wrote:
>> >> >
>> >> >> Thank you very much for the help you provided .. I really do appreciate it
>> >> >> Regards,
>> >> >> Tahani
>> >> >>
>> >> >> "Niek Otten" wrote:
>> >> >>
>> >> >> > http://support.microsoft.com/default...;EN-US;q213360
>> >> >> >
>> >> >> > --
>> >> >> >
>> >> >> > Kind Regards,
>> >> >> >
>> >> >> > Niek Otten
>> >> >> >
>> >> >> > Microsoft MVP - Excel
>> >> >> >
>> >> >> > "Excel_Instructor" <Excel_Instructor@discussions.microsoft.com> wrote in
>> >> >> > message news:8F661A1B-1204-415D-94A8-885B705FE7DA@microsoft.com...
>> >> >> > > how to convert a currency number (for example $100) into a text
>> >> >> > > representing
>> >> >> > > that number (one hundred dollars only)
>> >> >> >
>> >> >> >
>> >> >> >
>> >>
>> >>
>>
>>