convert currency to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
i want to convert "1000" in text like "One Thousand" in excell by formula

is it possible

mahbub
 
mahbub

Yes it is possible.

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


Gord Dibben MS Excel MVP
 
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
 
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
 
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
 
The instructions given at

http://support.microsoft.com/default.aspx?scid=kb;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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONVERTING CURRENCY TO WORDS 1
convert to text problem 2
Converting currency value into text 3
News Bank of England considers digital currency 4
Convert 1
Currency to text 1
Convert $12.25 to "twelve and 25/100 dollars" in Excel? 5
Formatting Currency Without Any Special Characters 3

Back
Top