G Guest Feb 4, 2005 #1 how to convert a currency number (for example $100) into a text representing that number (one hundred dollars only)
how to convert a currency number (for example $100) into a text representing that number (one hundred dollars only)
N Niek Otten Feb 4, 2005 #2 http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360 -- Kind Regards, Niek Otten Microsoft MVP - Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360 -- Kind Regards, Niek Otten Microsoft MVP - Excel
G Guest Feb 4, 2005 #3 Thank you very much for the help you provided .. I really do appreciate it Regards, Tahani
G Guest Jun 13, 2006 #4 i want to convert "1000" in text like "One Thousand" in excell by formula is it possible mahbub
G Gord Dibben Jun 13, 2006 #5 mahbub Yes it is possible. Go to the website Nick provided below and see what is required. Gord Dibben MS Excel MVP
mahbub Yes it is possible. Go to the website Nick provided below and see what is required. Gord Dibben MS Excel MVP
G Guest Jun 14, 2006 #6 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
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
G Gord Dibben Jun 14, 2006 #7 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
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
G Guest Jun 15, 2006 #8 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
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
G Gord Dibben Jun 15, 2006 #9 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
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
