A
Abdul Shakeel
Hi All,
Is there is any macro to divide a cell or range by 1000
Is there is any macro to divide a cell or range by 1000
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
You can divide by using Edit/ Paste Special/ Divide, so you could record a
macro to do that.
macro to do that.
B
Bob Phillips
You can do it with Excel
Type 1000 into a spare cell
Copy that cell
Select the range to divide in to
Goto Edit>Pastespecial
Click the Divide option
OK
Clear that spare cell
Type 1000 into a spare cell
Copy that cell
Select the range to divide in to
Goto Edit>Pastespecial
Click the Divide option
OK
Clear that spare cell
A
Abdul Shakeel
Dear Bob,
Thanks for your response but I dont want to use formula in this case I just
want that I select that particuler cell or range & press some key combination
to run the macro that divide by 1000 the select range or a single cell
Thanks for your response but I dont want to use formula in this case I just
want that I select that particuler cell or range & press some key combination
to run the macro that divide by 1000 the select range or a single cell
B
Bob Phillips
Follow David's advice then, do what I did with the macro recorder on.