Divide Function
 

I have a row of numbers that all need to be divided by 3. I need the answers
to show up in the column next to them. Does anyone know how I do this?

Divide Function
 

so, you have a number in A1, need the result in B1, value in C1, need result
in D1, etc.?

If it's like that, type =A1/3 in B1, then copy B1, highlight row 1, Edit -
Go to - Special - Blanks, paste.

All done!

"JMW" wrote:

I have a row of numbers that all need to be divided by 3. I need the answers
to show up in the column next to them. Does anyone know how I do this?

Divide Function
 

Numbers in column A

In B1 enter =A1/3

Double-click on the fill handle of B1 to copy down.


Gord Dibben MS Excel MVP

On Thu, 16 Oct 2008 13:35:03 -0700, JMW
wrote:

I have a row of numbers that all need to be divided by 3. I need the answers
to show up in the column next to them. Does anyone know how I do this?