Range or Selection Divided by "1000"

  • Thread starter Thread starter Abdul Shakeel
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Divide By 6
Divide Cells on a spreadsheet by 1000 3
Dividing cells by 1000 1
Command Buttons 4
New To Pivot Tables 4
Global change to cell values 2
Custom Format to divide by 10 2
MACRO SELECT COLUMN 2

Back
Top