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
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
