Dividing a column

[JMW]

I have a 200 cell column of numbers that each need to be divided by three. I
don't want to do this one by one. Os there a way to divide each different by
3 and have the answer show up in the cell next to them?

 

[DoubleZ]

If your first cell is A1, then in B1 enter the following: =A1/3

Then autofill down the column as far as you need (i.e. grab the lower right
hand corner of cell B1 and drag down)

DoubleZ

 

[Gord Dibben]

See one reply to your other post in this newsgroup.

No point in posting more than once or in more than one newsgroup.

All the regulars monitor all the newsgroups.

Multi-posting just tends to duplicate answers.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

If your data is in A1:A200, you could select B1:B200.
Type this:
=a1/3
and hit ctrl-enter to fill the selected range with the correct formula.

If you wanted to just divide the original values by 3 (in place), you could use:
Enter 3 into an empty cell
Edit|copy
Select A1:A200
edit|paste special|check divide and values
Clear the cell with the 3.