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
|