Dividing cells by 1000

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
Range or Selection Divided by "1000" 3
New To Pivot Tables 4
Command Buttons 4
Custom Format to divide by 10 2
working out % of correctness gives #DIV/0! 2
Summing Contiguous Values in a Column? 6

Back
Top