Thank you for your help!!!! But Sir I am using 2003 excel & i m working on networking PC thus I think the add-in did not install properly.
On Tue, Oct 5, 2010 at 12:35 PM, P.VIJAYKUMAR <vijay.4...@gmail.com> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
