how do i get all numbers in cells to be divided by 9 at once?

R

Ryan

I need to divide all the numbers in 200 cells by 9. How do I do that at one
time? I tried copying but did not work.
 
B

Bob Phillips

Enter 9 in an empty cell.
Copy that cell.
Select all of your target cells.
Menu Edit>PasteSpecial, and click the divide option in the Operation section
OK

Clear the cell with 9 in.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Duke Carey

Put 9 in an empty cell and copy it

Select the 200 cells
From the menu choose Edit | Paste special | divide, and you may want to
select Values as well
Click on OK
 
Top