Hi,
If you want only to display the number in that format it's possible to set a
Custom Number Format with the following mask:
#.000,
Regards!
2009/4/23 ASHUTOSH AGARWAL
> U can also use paste special function...write "1000" in a cell...copy
> it...select the data to be dividedthen
>
U can also use paste special function...write "1000" in a cell...copy
it...select the data to be dividedthen
paste special...formuladivide.
Hope that it will serve the purpose...
2009/4/23 N.Shivkumar
> I am enclosing the excel file without a macro. Hope the same serves your
> purp
I am enclosing the excel file without a macro. Hope the same serves your
purpose.
Bye and with best wishes
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685423
Res.: +914040035774
Alternate Email: shiv1...@yahoo.com
--~--~-~--~~~---~--~~
-
See attached file.
On Sun, Apr 19, 2009 at 10:09 PM, Mayank Patel 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 <26may.1...@gmail.com>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 <26may.1...@gmail.com> wrote:
>
> Hi Mayank,
>
> Try this VBA code.
> 1. Select the cells and run the code below:
> 2. Code:
> S
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 -->
h
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 wrote:
>
> Hi friends
> can anyone tell is thr any way to divide the cell in place.
> i am having the large scattered
