Convert Metric to Inch with Excel

[CNCJIM]

In a excel file I need to convert a metric number in a cell then put the result back into the cell the metric number originally was.
Then do it again with a different cell, different value.

 

[handleman]

Try multiplying or dividing by a conversion factor.

-handleman, CSWP (The new, easy test)

 

[electricpete]

If it helps, the analysis tookpak has a convert function
=+CONVERT(1,"in","m")
returns 0.0254

Let's say you had 3 columns
A-OldUnit B-OldValue C-NewUnit D-NewValue

You could calculate column D using formula like
D2 =+CONVERT(B2,A2,C2)

To put the results into the same location will require some sort of macro.


=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[MintJulep]

Do the cells that you need to convert contain values or formulas?

If they contain values, then you could use paste special to multiply by the appropriate factor.

If they contain formulas, simply modify the formula.

 

[Clyde38]

How about the "Copy" and "Paste Special" using the conversion as the value you copy and applying an "Operation" (Add, Subtract, Multiply or Divide) to the cell(s) you want to convert with "Paste Special"?