On Jan 29, 6:01*pm, Pete_UK wrote:
Choose an empty cell somewhere and put 1000 in that cell. Select the
cell and click <copy, then move your cursor to highlight your 120
cells in the other column, right-click and select Paste Special |
Values (check) | Divide (check) | OK then <Esc.

Then you can delete the cell containing the original 1000.

Hope this helps.

Pete

On Jan 29, 12:54*pm, wrote:



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.- Hide quoted text -

- Show quoted text -

Thanks a ton! Problem solved.