See attached file.
On Sun, Apr 19, 2009 at 10:09 PM, Mayank Patel <[email protected]> wrote: > 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 <[email protected]>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 <[email protected]> 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 <[email protected]> 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 <[email protected]> >> 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 >> >> > > > > -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
ddfs.xls
Description: MS-Excel spreadsheet
