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 <ashishj...@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 <radhe2...@gmail.com> 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 <ashishj...@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 <radhe2...@gmail.com> 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: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet