This may not be what you want or need, but just in case...

If you really wanted to end up with the values in column A divided by 10, you
could:

Put 10 in an empty cell
Edit|copy that cell
Select the numbers in column A that should be changed
Edit|paste special|click divide and values
then clear that cell with 10 in it.



Robert11 wrote:

Hello,

Embarrased to ask something so simple, but am in my 70's now, and haven't
used Excel in quite a whle.

Have a long column "A" of numbers.

Would like to create an adjacent column, B, with each number in the first
column A being divided by, e.g., 10.
(and showing up in this adjacent B column)

So, I select the first column, and now what, please ?

Much thanks,
appreciate the help.

Bob

--

Dave Peterson