Divide every number in a column by 1000

[JCScoobyRS]

I have 5 rows, each of which I need to divide each cell by 1000. Is there a quick way to do this? Thanks, Jermey

 

[plettieri]

maybe a little more info would help...so see what you are try to do....but a simple =a1/1000 then copy formular accross and down to the level you want...

pll

 

[Excelclumsy]

yes it works. drag the formula from the dot at the bottom of the selected cell. Very useful advice! thank you!

 

[pgc01]

yes it works. drag the formula from the dot at the bottom of the selected cell. Very useful advice! thank you!

Another option:

- in a cell write 1000
- Copy
- select the range
- Paste Special -> Divide