Converting a range of cells from tons to metric tons

  • Thread starter Thread starter Guest
  • Start date Start date
G

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