Do same operation on an entire column and put the data in the col itself
 

Hi,

I have a column,

A B C
=====

25,970.50
263
26,233.50
4,285.50
4,287.90

What i want to do is divide each cell in A by 10 and put the result in
A itself. Is there any way to do this other than first putting the
result in another column B and then copying it into A. I am sure there
would a simpler way to operate an entire range of cells with a single
operation/transformation.

Thanx in advance

~som

Do same operation on an entire column and put the data in the col itself
 

Try this:

Enter 10 in an empty cell
Copy that cell: EditCopy
Select the range of cells in question in column A
Then do: EditPaste SpecialDivideOK

Clear the 10 from the helper cell

Biff

"som" wrote in message
ups.com...
Hi,

I have a column,

A B C
=====

25,970.50
263
26,233.50
4,285.50
4,287.90

What i want to do is divide each cell in A by 10 and put the result in
A itself. Is there any way to do this other than first putting the
result in another column B and then copying it into A. I am sure there
would a simpler way to operate an entire range of cells with a single
operation/transformation.

Thanx in advance

~som