| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert figure to words
I want to convert an amount like 587 to Five hundred Eighty Seven. How Pl. help
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert figure to words
Hi,
Install the Morefunc addin which will provide many new Excel functions including =NBTEXT() Which does number to words conversions. http://xcell05.free.fr/english/ alternatively do it with code http://www.ozgrid.com/VBA/ValueToWords.htm Mike Mike "Ashish Saxena" wrote: I want to convert an amount like 587 to Five hundred Eighty Seven. How Pl. help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert figure to words
Dear Sir,
Thanks for reply. Pl. know me that which add-in need to be install Ashish "Mike H" wrote: Hi, Install the Morefunc addin which will provide many new Excel functions including =NBTEXT() Which does number to words conversions. http://xcell05.free.fr/english/ alternatively do it with code http://www.ozgrid.com/VBA/ValueToWords.htm Mike Mike "Ashish Saxena" wrote: I want to convert an amount like 587 to Five hundred Eighty Seven. How Pl. help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert figure to words
The addin is called 'Morefunc' and you get it by following the link in my
last post Mike "Ashish Saxena" wrote: Dear Sir, Thanks for reply. Pl. know me that which add-in need to be install Ashish "Mike H" wrote: Hi, Install the Morefunc addin which will provide many new Excel functions including =NBTEXT() Which does number to words conversions. http://xcell05.free.fr/english/ alternatively do it with code http://www.ozgrid.com/VBA/ValueToWords.htm Mike Mike "Ashish Saxena" wrote: I want to convert an amount like 587 to Five hundred Eighty Seven. How Pl. help |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert figure to words
This is a great resource for such things:
http://www.xldynamic.com/source/xld.xlFAQ0004.html Regards, Ryan--- -- RyGuy "Mike H" wrote: The addin is called 'Morefunc' and you get it by following the link in my last post Mike "Ashish Saxena" wrote: Dear Sir, Thanks for reply. Pl. know me that which add-in need to be install Ashish "Mike H" wrote: Hi, Install the Morefunc addin which will provide many new Excel functions including =NBTEXT() Which does number to words conversions. http://xcell05.free.fr/english/ alternatively do it with code http://www.ozgrid.com/VBA/ValueToWords.htm Mike Mike "Ashish Saxena" wrote: I want to convert an amount like 587 to Five hundred Eighty Seven. How Pl. help |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert figure to words
Look here is you are having trouble setting it up:
http://www.freefilehosting.net/download/3g27h -- RyGuy "Mike H" wrote: The addin is called 'Morefunc' and you get it by following the link in my last post Mike "Ashish Saxena" wrote: Dear Sir, Thanks for reply. Pl. know me that which add-in need to be install Ashish "Mike H" wrote: Hi, Install the Morefunc addin which will provide many new Excel functions including =NBTEXT() Which does number to words conversions. http://xcell05.free.fr/english/ alternatively do it with code http://www.ozgrid.com/VBA/ValueToWords.htm Mike Mike "Ashish Saxena" wrote: I want to convert an amount like 587 to Five hundred Eighty Seven. How Pl. help |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert figure to words
Hi Ashish, In case you need to convert amount in words as per Indian number system (using Lakh, Crore) and formatting cells as per Indian Decimal System (e.g. 1234567.00 to 12,34,567.00) you can download one free addins "Indian Rupees" from below site. http://in.geocities.com/shahshaileshs/ Or download one workbook "indianspellnoformula" (scroll to 5 or 4 for English) from below webpage, which has formula to convert numbers to words as per Indian System. No VBA codes required. http://in.geocities.com/shahshaileshs/misc.htm Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins "Ashish Saxena" wrote in message ... I want to convert an amount like 587 to Five hundred Eighty Seven. How Pl. help |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert figure to words
Hi,
I have a non macro solution on my website. Please refer to question 9 on the following link http://ashishmathur.com/solutions.aspx. -- Regards, Ashish Mathur www.ashishmathur.com http://www.linkedin.com/in/excelenthusiasts "Ashish Saxena" wrote in message ... I want to convert an amount like 587 to Five hundred Eighty Seven. How Pl. help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting a figure into words | Excel Worksheet Functions | |||
| how to change figure to words | Excel Worksheet Functions | |||
| how to convert a figure in words? | Excel Discussion (Misc queries) | |||
| Is their any Function to convert no. in figure to in words | Excel Worksheet Functions | |||
| Conversion of Figure in Words | Excel Worksheet Functions | |||
Linear Mode
