Convert Metric to Inch with Excel
Convert Metric to Inch with Excel
(OP)
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.
Then do it again with a different cell, different value.





RE: Convert Metric to Inch with Excel
-handleman, CSWP (The new, easy test)
RE: Convert Metric to Inch with Excel
=+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.
RE: Convert Metric to Inch with Excel
If they contain values, then you could use paste special to multiply by the appropriate factor.
If they contain formulas, simply modify the formula.
RE: Convert Metric to Inch with Excel