Hey Anil,
Please use this formula =ASAPSPELLNUMBER(A1). The function is
already present in ASAP Utilities.
Thanks,
Rajesh Kunder
On Mon, Jun 22, 2009 at 4:00 PM, Anil Kumar Agarwala
<akagarw...@gmail.com>wrote:> Dear Rajesh, > > Sorry I was not aware. Could you point out the exact menu/submenu? > > Thanks in advance > > > > *[image: CA_logo_icai Small1]* > > *Anil Kumar Agarwala* > > *Anil Agarwala & Co.* > > *Chartered Accountants* > > 3rd Floor, Adiba Mansion > > Maszid Lane, Kamarpatty > > Fancy Bazar > > Guwahati : 781001 > > Assam > > +91 361 2638864 (Telefax) > > +91 361 2517820 (Office) > > +91 361 2606184 (Residence) > > +91 9435086605 (Mobile) > > akagarw...@gmail.com > > > > *From:* Rajesh Kunder [mailto:kunder....@gmail.com] > *Sent:* Monday, June 22, 2009 2:14 PM > *To:* excel-macros@googlegroups.com > *Cc:* akagarw...@gmail.com > *Subject:* Re: $$Excel-Macros$$ Re: Conversion of value in words from > figures > > > > Hey Anil Kumar, > > > > This feature is there in ASAP Utilities. > > > > Thanks, > > Rajesh Kunder > > On Mon, Jun 22, 2009 at 1:00 PM, Anil Kumar Agarwala <akagarw...@gmail.com> > wrote: > > Dear Shiv Pratap > > There is no built in function in excel to do it. You have to use custom > made function for the same which are quite difficult to come by (even ASAP > utilities does not provide for one!). > > > > *[image: CA_logo_icai Small1]* > > *Anil Kumar Agarwala* > > *Anil Agarwala & Co.* > > *Chartered Accountants* > > 3rd Floor, Adiba Mansion > > Maszid Lane, Kamarpatty > > Fancy Bazar > > Guwahati : 781001 > > Assam > > +91 361 2638864 (Telefax) > > +91 361 2517820 (Office) > > +91 361 2606184 (Residence) > > +91 9435086605 (Mobile) > > akagarw...@gmail.com > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Shiv Pratap > *Sent:* Sunday, June 21, 2009 6:43 PM > > > *To:* excel-macros@googlegroups.com > *Cc:* megaliving_corporat...@yahoo.com; megaliving.corporat...@gmail.com; > vibhor_rast...@baxter.com > *Subject:* $$Excel-Macros$$ Conversion of value in words from figures > > > > Hi Friends, > > > > I have a simple query in my mind. > > I just wants to know that is it possible to convert a numeric value written > in a cell in figures into words in another cell. > > For Example :- > > Numeric value in figures = 123 > > Value in words = One hundred twenty three > > > > If it is possible then plzz suggest me the way. > > > > Regards > > Shiv Pratap > > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
<<inline: image002.jpg>>
<<inline: image003.jpg>>
