Multiplyor divide cells by 1000

A

Anders Silven

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
 
A

ajb

Thank you, thank you, thank you, thank you, thank
you.........................................................................
.............
.............................................................................
..................
.........................................thank you!!!!!!!!!!!!!
 
Top