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!!!!!!!!!!!!!
 
Back
Top