You can input this value in any cell, then copy the same and do a paste special in all particular cells. select values and divide function for same.
Aj On 4/2/09, 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 > > > > -- Ajay Kashyap ________________________ We can make it happen..the only thing that is required is to "TRY" --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
