Converting a range of cells from tons to metric tons

[Guest]

I am using Excel 2003 and I have tried everything from recording macros,
researching formulas, etc. I do a daily report that I need to convert
numerous cells from tons to metric. I currently go into each cell and
/1.10231. I want to be able to do this to all applicable cells all at once
or at least create some form of shortcut (it's a huge spreadsheet) that would
make this faster. Any ideas?

 

[Peo Sjoblom]

Always make a back up first, then put 1.10231 in an empty cell, select it,
copy it, select all cells to be converted, do edit>past special and select
divide


You can also use a formula in a help cell, assume the US ton is in A3

=A3/1.10231


copy down as long as needed, the benefit using a formula is that you have a
trail if something goes wrong

another formula


=CONVERT(A3*2000,"lbm","g")/1000^2

will convert it to metric ton as well via pound and grams


note that the CONVERT function is part of the ATP

 

[Gord Dibben]

Place 1.10231 into an empty cell.

Copy that cell.

Select the range of cells to convert and Edit>Paste Special>Divide>OK>Esc

Clear the 1.10231 from the cell.

Or same as above but multiply by .907185


Gord Dibben MS Excel MVP