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)