Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007
Hi Ashish, Many thanks for the kind help in providing valuable information about Openexcel. Probably the communication from my side was not clear The help i was seeking was to convert the value to be mentioned in words For example if a cell has 523.25; this value should be displayed in words as Rupees Five Hundred Twenty Three and Paise Twenty Five Only" Earlier a group member has provided an addin "Num2text.xla" which helped in getting the desired result. This addin is not working in Excel 2007 Looking forward to your kind help please Many thanks and best regards Radhe On Tue, Dec 7, 2010 at 3:57 PM, OpenExcel.com wrote: > Hi Radhe, > > It seems you don't know about 'Open Excel'. Download and you can do > many things other than this. > > > Thanks & Regards > Ashish Jain > (Microsoft Certified Application Specialist) > (Microsoft Certified Professional) > http://www.excelitems.com > http://www.openexcel.com > > > On Dec 7, 2:13 pm, Radhe Sham wrote: > > Hi Group , > > > > The addin for converting a number to text which was working in Excel > 2003 > > does not seem to work in Excel 2007 > > > > Can anyone kindly help with an add in for Excel 2007 for converting > number > > to text please > > > > Thanks and regards > > Radhe > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007
Hi Radhe, 1. Download Open Excel from http://www.openexcel.com 2. Install it 3. Open your Workbook. 4. Go to 'Open XL' tab. 5. Go to 'Number Utils' 6. Click on 'Spell Numbers' and you're done. It does exactly what you mentioned and have around 100 more useful utilities, you probably would be using daily. Check it out ! Thanks & Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Dec 7, 5:22 pm, Radhe Sham wrote: > Hi Ashish, > > Many thanks for the kind help in providing valuable information about > Openexcel. > > Probably the communication from my side was not clear > > The help i was seeking was to convert the value to be mentioned in words > > For example if a cell has 523.25; this value should be displayed in words as > Rupees Five Hundred Twenty Three and Paise Twenty Five Only" > > Earlier a group member has provided an addin "Num2text.xla" which helped in > getting the desired result. This addin is not working in Excel 2007 > > Looking forward to your kind help please > > Many thanks and best regards > Radhe > On Tue, Dec 7, 2010 at 3:57 PM, OpenExcel.com wrote: > > > > > > > > > Hi Radhe, > > > It seems you don't know about 'Open Excel'. Download and you can do > > many things other than this. > > > > > Thanks & Regards > > Ashish Jain > > (Microsoft Certified Application Specialist) > > (Microsoft Certified Professional) > >http://www.excelitems.com > >http://www.openexcel.com > > > > > On Dec 7, 2:13 pm, Radhe Sham wrote: > > > Hi Group , > > > > The addin for converting a number to text which was working in Excel > > 2003 > > > does not seem to work in Excel 2007 > > > > Can anyone kindly help with an add in for Excel 2007 for converting > > number > > > to text please > > > > Thanks and regards > > > Radhe > > > -- > > > --- > > --- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007
Try this link out... http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html Regards, Manoj Vishwakarma On Tue, Dec 7, 2010 at 5:52 PM, Radhe Sham wrote: > Hi Ashish, > > Many thanks for the kind help in providing valuable information about > Openexcel. > > Probably the communication from my side was not clear > > The help i was seeking was to convert the value to be mentioned in words > > For example if a cell has 523.25; this value should be displayed in words > as Rupees Five Hundred Twenty Three and Paise Twenty Five Only" > > Earlier a group member has provided an addin "Num2text.xla" which helped in > getting the desired result. This addin is not working in Excel 2007 > > Looking forward to your kind help please > > Many thanks and best regards > Radhe > On Tue, Dec 7, 2010 at 3:57 PM, OpenExcel.com wrote: > >> Hi Radhe, >> >> It seems you don't know about 'Open Excel'. Download and you can do >> many things other than this. >> >> >> Thanks & Regards >> Ashish Jain >> (Microsoft Certified Application Specialist) >> (Microsoft Certified Professional) >> http://www.excelitems.com >> http://www.openexcel.com >> >> >> On Dec 7, 2:13 pm, Radhe Sham wrote: >> > Hi Group , >> > >> > The addin for converting a number to text which was working in Excel >> 2003 >> > does not seem to work in Excel 2007 >> > >> > Can anyone kindly help with an add in for Excel 2007 for converting >> number >> > to text please >> > >> > Thanks and regards >> > Radhe >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007
HI Ashish , Sorry to trouble you again Spell Numbers convers the number into words in the same location while what is requires is the numbers are to be translated into words in a different location. I have attached a file with the format in which the numbers are requires to be mentioned in words Also, Spell Numbers converts the values in Dollars and Cents which probably would not help in India as we would require the amount in Local currency Thanks for the personal support being extended Best regards Radhe On Tue, Dec 7, 2010 at 6:51 PM, OpenExcel.com wrote: > Hi Radhe, > > 1. Download Open Excel from http://www.openexcel.com > 2. Install it > 3. Open your Workbook. > 4. Go to 'Open XL' tab. > 5. Go to 'Number Utils' > 6. Click on 'Spell Numbers' and you're done. > > It does exactly what you mentioned and have around 100 more useful > utilities, you probably would be using daily. Check it out ! > > > Thanks & Regards > Ashish Jain > (Microsoft Certified Application Specialist) > (Microsoft Certified Professional) > http://www.excelitems.com > http://www.openexcel.com > > > On Dec 7, 5:22 pm, Radhe Sham wrote: > > Hi Ashish, > > > > Many thanks for the kind help in providing valuable information about > > Openexcel. > > > > Probably the communication from my side was not clear > > > > The help i was seeking was to convert the value to be mentioned in words > > > > For example if a cell has 523.25; this value should be displayed in words > as > > Rupees Five Hundred Twenty Three and Paise Twenty Five Only" > > > > Earlier a group member has provided an addin "Num2text.xla" which helped > in > > getting the desired result. This addin is not working in Excel 2007 > > > > Looking forward to your kind help please > > > > Many thanks and best regards > > Radhe > > On Tue, Dec 7, 2010 at 3:57 PM, OpenExcel.com >wrote: > > > > > > > > > > > > > > > > > Hi Radhe, > > > > > It seems you don't know about 'Open Excel'. Download and you can do > > > many things other than this. > > > > > > > > Thanks & Regards > > > Ashish Jain > > > (Microsoft Certified Application Specialist) > > > (Microsoft Certified Professional) > > >http://www.excelitems.com > > >http://www.openexcel.com > > > > > > > > On Dec 7, 2:13 pm, Radhe Sham wrote: > > > > Hi Group , > > > > > > The addin for converting a number to text which was working in Excel > > > 2003 > > > > does not seem to work in Excel 2007 > > > > > > Can anyone kindly help with an add in for Excel 2007 for converting > > > number > > > > to text please > > > > > > Thanks and regards > > > > Radhe > > > > > -- > > > > > > --- > --- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below link > > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;. > .. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts Example.xlsx Description
Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007
You can use substitute in front of the UDF to replace the word to your desired local currency right. Another Method:- Follow the below link and download the MoreFuction Addin from that and run the setup. http://download.cnet.com/Morefunc/3000-2077_4-10423159.html After doing that open excel and goto Tools>>Add-Ins>Check the Morefunc(add-in Function)>>Ok Then go to Insert>>Functions>>Select a Category>>Select Morefun>>Select a Funcion:>>Select NBTEXT>>Ok You can find more functions in that addin. --- Ms.Exl.Learner --- On Tue, Dec 7, 2010 at 8:15 PM, Radhe Sham wrote: > HI Ashish , > > Sorry to trouble you again > > Spell Numbers convers the number into words in the same location while what > is requires is the numbers are to be translated into words in a different > location. I have attached a file with the format in which the numbers are > requires to be mentioned in words > > Also, Spell Numbers converts the values in Dollars and Cents which probably > would not help in India as we would require the amount in Local currency > Thanks for the personal support being extended > > > Best regards > Radhe > On Tue, Dec 7, 2010 at 6:51 PM, OpenExcel.com wrote: > >> Hi Radhe, >> >> 1. Download Open Excel from http://www.openexcel.com >> 2. Install it >> 3. Open your Workbook. >> 4. Go to 'Open XL' tab. >> 5. Go to 'Number Utils' >> 6. Click on 'Spell Numbers' and you're done. >> >> It does exactly what you mentioned and have around 100 more useful >> utilities, you probably would be using daily. Check it out ! >> >> >> Thanks & Regards >> Ashish Jain >> (Microsoft Certified Application Specialist) >> (Microsoft Certified Professional) >> http://www.excelitems.com >> http://www.openexcel.com >> >> >> On Dec 7, 5:22 pm, Radhe Sham wrote: >> > Hi Ashish, >> > >> > Many thanks for the kind help in providing valuable information about >> > Openexcel. >> > >> > Probably the communication from my side was not clear >> > >> > The help i was seeking was to convert the value to be mentioned in words >> > >> > For example if a cell has 523.25; this value should be displayed in >> words as >> > Rupees Five Hundred Twenty Three and Paise Twenty Five Only" >> > >> > Earlier a group member has provided an addin "Num2text.xla" which helped >> in >> > getting the desired result. This addin is not working in Excel 2007 >> > >> > Looking forward to your kind help please >> > >> > Many thanks and best regards >> > Radhe >> > On Tue, Dec 7, 2010 at 3:57 PM, OpenExcel.com > >wrote: >> > >> > >> > >> > >> > >> > >> > >> > > Hi Radhe, >> > >> > > It seems you don't know about 'Open Excel'. Download and you can do >> > > many things other than this. >> > >> > > >> > > Thanks & Regards >> > > Ashish Jain >> > > (Microsoft Certified Application Specialist) >> > > (Microsoft Certified Professional) >> > >http://www.excelitems.com >> > >http://www.openexcel.com >> > > >> > >> > > On Dec 7, 2:13 pm, Radhe Sham wrote: >> > > > Hi Group , >> > >> > > > The addin for converting a number to text which was working in >> Excel >> > > 2003 >> > > > does not seem to work in Excel 2007 >> > >> > > > Can anyone kindly help with an add in for Excel 2007 for converting >> > > number >> > > > to text please >> > >> > > > Thanks and regards >> > > > Radhe >> > >> > > -- >> > >> > > >> --- >> --- >> > > Some important links for excel users: >> > > 1. Follow us on TWITTER for tips tricks and links : >> > >http://twitter.com/exceldailytip >> > > 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com >> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> > >> > > To post to this group, send email to excel-macros@googlegroups.com >> > >> > > <><><><><><><><><><><><><><><><><><><><><><> >> > > Like our page on facebook , Just follow below link >> > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;. >> .. >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/p
Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007
Hi, I am unable to download the OPEN XL, can any one help the procedure On Tue, Dec 7, 2010 at 5:52 PM, Radhe Sham wrote: > Hi Ashish, > > Many thanks for the kind help in providing valuable information about > Openexcel. > > Probably the communication from my side was not clear > > The help i was seeking was to convert the value to be mentioned in words > > For example if a cell has 523.25; this value should be displayed in words > as Rupees Five Hundred Twenty Three and Paise Twenty Five Only" > > Earlier a group member has provided an addin "Num2text.xla" which helped in > getting the desired result. This addin is not working in Excel 2007 > > Looking forward to your kind help please > > Many thanks and best regards > Radhe > On Tue, Dec 7, 2010 at 3:57 PM, OpenExcel.com wrote: > >> Hi Radhe, >> >> It seems you don't know about 'Open Excel'. Download and you can do >> many things other than this. >> >> >> Thanks & Regards >> Ashish Jain >> (Microsoft Certified Application Specialist) >> (Microsoft Certified Professional) >> http://www.excelitems.com >> http://www.openexcel.com >> >> >> On Dec 7, 2:13 pm, Radhe Sham wrote: >> > Hi Group , >> > >> > The addin for converting a number to text which was working in Excel >> 2003 >> > does not seem to work in Excel 2007 >> > >> > Can anyone kindly help with an add in for Excel 2007 for converting >> number >> > to text please >> > >> > Thanks and regards >> > Radhe >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts