Dividing cells by 1000

G

Guest

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?
 
G

Gord Dibben

Enter 1000 in an unused cell.

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

Edit>Paste Special(in place)>Divide>OK>Esc.

Clear the cell with the 1000.

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Divide Cells on a spreadsheet by 1000 3
Divide By 6
Summing Contiguous Values in a Column? 6
Range or Selection Divided by "1000" 3
Return Just the Unique Entries From a Range of Cells 3
#Value! 1
Daily Average 6
If formula and Data Validation parallely 1

Top