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" wrote in
message ...
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" wrote in
message ...
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" wrote in
message ...
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
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" wrote in
message ...
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
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" wrote in
message ...
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 ToolsAdd-ins.


Gord

On Wed, 14 Jun 2006 00:23:02 -0700, mahbub
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
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" wrote in
message ...
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 ToolsAdd-ins.


Gord

On Wed, 14 Jun 2006 00:23:02 -0700, mahbub
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
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" wrote in
message ...
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
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 ToolsAdd-ins.


Gord

On Wed, 14 Jun 2006 00:23:02 -0700, mahbub
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
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" wrote in
message ...
how to convert a currency number (for example $100) into a text
representing
that number (one hundred dollars only)