Thanks Ashish is there any other way than Macro I appreciate ur help.
Regards Mayank Patel ITC LTD 9822978041 9422749110 On Sun, Apr 19, 2009 at 9:08 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi Mayank, > > Try this VBA code. > 1. Select the cells and run the code below: > 2. Code: > Sub Divideby1000() > Dim myCell as Range > For each myCell in Selection.cells\ > myCell.Value = myCell.value/1000 > Next > End Sub > > > For more tips, tricks, downloads and problem solutions: visit --> > http://www.excelitems.com > ------------------------------------------------------------------------ > Regards > *Ashish **Jain* > Analyst, CSC > Microsoft Certified Application (Excel) Specialist > Excel and VBA Trainer > Author -> www.excelitems.com > +91-9999-40-48-43 > > ------------------------------------------------------------------------------------- > > ------------------------------------------------------------------------------------- > > On Apr 2, 9:22 pm, Mayank Patel <mkpat...@gmail.com> wrote: > > Hi friends > > can anyone tell is thr any way to divide the cell in place. > > i am having the large scattered data which i want to divide by 1000. > > Please Suggest > > > > Rgds > > > > Mayank > > > > > > > > On Thu, Apr 2, 2009 at 3:04 PM, Aindril De <aind...@gmail.com> wrote: > > > Hi Mahesh > > > > >http://office.microsoft.com/en-us/excel/HA102223271033.aspx > > > > > The above link will give you the answer. > > > > > Regards, > > > Andy > > > > > On Thu, Apr 2, 2009 at 12:38 AM, mahesh parab <mahes...@gmail.com> > wrote: > > > > >> Dear All > > > > >> Any knw macro in excel which can speak the cell content. or any user > > >> define function is there. if any one have > > >> example sheet please mail it to me. > > > > -- > > Regards > > Mayank Patel > > ITC LTD > > 9822978041 > > 9422749110 > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
