E
Excel_Instructor
how to convert a currency number (for example $100) into a text representing
that number (one hundred dollars only)
that number (one hundred dollars only)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
T
Tahani
Thank you very much for the help you provided .. I really do appreciate it
Regards,
Tahani
Regards,
Tahani
M
mahbub
i want to convert "1000" in text like "One Thousand" in excell by formula
is it possible
mahbub
is it possible
mahbub
G
Gord Dibben
mahbub
Yes it is possible.
Go to the website Nick provided below and see what is required.
Gord Dibben MS Excel MVP
Yes it is possible.
Go to the website Nick provided below and see what is required.
Gord Dibben MS Excel MVP
M
mahbub
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
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
G
Gord Dibben
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
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
M
mahbub
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
im accounts person. pls. make me more clear how can i use.
im sorry for disturbing u.
but i need ur help
thanks
G
Gord Dibben
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
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