In a blank cell, enter 1000
Copy this cell
Select the range of numbers to be fixed
Use Edit | Paste Special with Divide specified
Now delete the cell with 1000
Done!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

wrote in message
...
I have a column with 120 entries (numbers). I want to divide all by
1000 and show the new results in the same cells. Please help.