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?