Dear Ankit, To use the add-in select the number you want to convert into text.then go to the add-ins in the Menu bar and select the text to numbers button. Automaticaaly the number you selected turns into text. But, you dont't have the original number.If you want to have the number and also the converted text copy the number into another cell and then change it into text. In this way you can have both the number and also you converted text.Hope this clarifies your doubt.
Regards, Vijaykumar On Tue, Oct 5, 2010 at 11:38 AM, Ankit Agrawal <ankit.agrawal...@gmail.com>wrote: > Thank you sir for deteil knowledge but again same problem *how we can use > add-in? plz tell me * > > ** > Thnanks & Regards > > Ankit > > > On Tue, Oct 5, 2010 at 8:30 AM, P.VIJAYKUMAR <vijay.4...@gmail.com> wrote: > >> Dear Ankit, >> >> There is no Direct formula to convert numbers into text.But there are some >> add-ins available in the websites. just google for text to numbers converter >> in excel add-in. >> Once you download the add-in to install the add-in to excel go to the >> excel ribbon Button, the from there open excel options ,then select add-in >> from the avialble options. Excel will then display the add-ins which are >> already installed . It will also have a go button in the bottom for >> installing others in that it will show some available not installed >> add-ins,you can also install them along with our add-in..After clicking go >> button then click the browse button then select the file which you >> downloaded to any disk or any place in your computer.Then click OK.Your >> add-in is installed.Once installed the file which is selected for >> installation should not be moved from the place it is downloaded.To many >> movements make the add-in not working.So when downloading only make sure >> that the file is saved in a place in which is is not disturbed further.Once >> installed you add-in shall work in every workbook. Make sure that an addin >> button is added to the Menu Bar.Hope this clarified your problem >> >> >> Regards, >> VijayKumar >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 > -- P.VIJAY KUMAR -- ---------------------------------------------------------------------------------- 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
