|
convert currency to text
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) |
convert currency to text
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) |
convert currency to text
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) |
convert currency to text
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) |
convert currency to text
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) |
convert currency to text
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) |
convert currency to text
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) |
| All times are GMT +1. The time now is 12:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com