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

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.

Enter 9 in an empty cell.
Copy that cell.
Select all of your target cells.
Menu EditPasteSpecial, 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)


"Ryan" wrote in message
...
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.

Place a 9 in any cell. Select the 200 cells and hit Edit--Paste
special--Divide, OK.
*******************
~Anne Troy

www.OfficeArticles.com


"Ryan" wrote in message
...
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.

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


"Ryan" wrote:

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.