Enter 1000 in an un-used cell
Copy that cell
Select the cells ( or columns) that you want to change
Paste/Special/divide
--
Gary''s Student - gsnu200794


"Django" wrote:

Can anyone tell me if there is a way that I can divide the cells on a
spreadsheet by 1000 without going to each individual cell and dividing by
1000.
--
Django