Changing a Series of Numbers in an Excel sheet column

[KoolSIM]

Hi

I have a series of numbers in one column. Is there some way I can divide all the numbers together by, say 10, without doing it manually?

eg.

12
15
15
25
20

should become

1.2
1.5
1.5
2.5
2.0

Is there a way in Excel to do that?

[shg]

Put 10 in a cell and do Edit > Copy.

Select the other cells, do Edit > Paste special, tick Divide and Values

[zbor]

Or in one cell (eg B1) put number (wich you can change as you need) eg 10.

Then in C1 write =A1/$B$1 and extend down while you have data

[KoolSIM]

thanks a lot people!!! finally I know one more thing out of a billion things in Excel!