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

Place 1.10231 into an empty cell.

Copy that cell.

Select the range of cells to convert and EditPaste SpecialDivideOKEsc

Clear the 1.10231 from the cell.

Or same as above but multiply by .907185


Gord Dibben MS Excel MVP

On Thu, 2 Aug 2007 14:56:02 -0700, Brooksl
wrote:

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?