Dividing cells by 1000
 

I have a document in which I have to do my report in thousands i.e. $1000
represents $1,000,000. How do I divide each data cell by 1000 without
individually dividing each cell by 1000?
--
Django

Dividing cells by 1000
 

Enter 1000 in an unused cell.

Copy that cell then select your range of cells to change.

EditPaste Special(in place)DivideOKEsc.

Clear the cell with the 1000.

OR if for visual appearance only or printing, custom format the cells to #,


Gord Dibben MS Excel MVP

On Sat, 25 Aug 2007 07:24:01 -0700, Django wrote:

I have a document in which I have to do my report in thousands i.e. $1000
represents $1,000,000. How do I divide each data cell by 1000 without
individually dividing each cell by 1000?