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 editpast 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




--
Regards,

Peo Sjoblom




"Brooksl" wrote in message
...
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?