Range or Selection Divided by "1000"

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

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
New To Pivot Tables 4
MACRO SELECT COLUMN 2
Command Buttons 4
Return Just the Unique Entries From a Range of Cells 3
Global change to cell values 2

Top