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 <radhe2...@gmail.com> 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 <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 > -- -- ---------------------------------------------------------------------------------- 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
