Inch equivalent in MM?
Inch equivalent in MM?
(OP)
Is there a formula that you can create within an Excel Spreadsheet that would give you the Inch equivalent in MM?
1.000 [25,4]
fyi: I'm a novice at using Excel, so specifics would work. Or an actual spreadsheet.
thanks.
1.000 [25,4]
fyi: I'm a novice at using Excel, so specifics would work. Or an actual spreadsheet.
thanks.





RE: Inch equivalent in MM?
Then put the following formula in cell B2: +A2*25.4
B2 is the length in mm.
Or have I misunderstood the question.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Inch equivalent in MM?
Then put the following formula in cell B2: =A2*25.4
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk
RE: Inch equivalent in MM?
=CONVERT(E6,"in","mm")
Where cell E6 would contain the number you want to convert from inch to mm.
RE: Inch equivalent in MM?
RE: Inch equivalent in MM?
RE: Inch equivalent in MM?
Going back to original question I suspect maybe you were asking about formatting the output when you wrote
1.000 [25,4]
If you had a value of inches (1.0) in A2 you could put the following in B2
=+TEXT(A2,"#.000")&" inch "&"["&+TEXT(A2*25.4,"#.00")&"mm]"
And the display in B2 would read
1.000 inch [25.40mm]
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Inch equivalent in MM?
CODE
'Function to convert inches to mm
in2mm = x * 25.4
End Function
Now save the work book as an "addin" (a *.xla file) with a recognizable name (eg personal-functions.xla).
Close Excel, and restart. Go to the tools menu >> add-ins and select the add-in "personal-functions".
You have now created your own add-in and any functions you edit or add to it will be easily accessible to any spreadsheet to create.
So for instance to use your new function you would simply eneter "=in2mm(12)" into a cell, and that cell should display "304.8".
Personal functions can be VERY useful :)
Must admit I did not know about the convert function either though! Thanks!
Read the FAQ ... ht tp://www.e ng-tips.co m/faqs.cfm ?pid=731&a mp;fid=376
RE: Inch equivalent in MM?
only i'd use number formating to show 3 decimal places ... what if cam721 wants 1.2" ?