Multiplyor divide cells by 1000

  • Thread starter Thread starter ajb
  • Start date Start date
To change all values once and for all,

- enter 1000 in an empty cell
- copy that cell
- select all cells with the numbers you want to change, *not* the whole sheet
- do Edit>Paste Special>Divide>OK

HTH
Anders Silven
 
Thank you, thank you, thank you, thank you, thank
you.........................................................................
.............
.............................................................................
..................
.........................................thank you!!!!!!!!!!!!!
 
Thank you for the feedback. Glad it helped.

Best regards,
Anders Silven
 
You must log in or register to reply here.

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

Automatic division by 1000 1
Divide Cells on a spreadsheet by 1000 3
Number entries are automatically divided by 100 - Excel 2003 1
Divide By 6
Dividing cells by 1000 1
number format in excel 3
automate cell to divide by 1000 3
Range or Selection Divided by "1000" 3

Back
Top