Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Inch equivalent in MM?

Inch equivalent in MM?

Inch equivalent in MM?

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.


RE: Inch equivalent in MM?

I the length in inches is in cell A2
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?

looks like ElectricPete's finger got stuck on the Shift key. Try:

Then put the following formula in cell B2:  =A2*25.4

Good Luck
To get the best from these forums read FAQ731-376 before posting

Steam Engine enthusiasts: www.essexsteam.co.uk

RE: Inch equivalent in MM?

You could also use the convert function:

Where cell E6 would contain the number you want to convert from inch to mm.

RE: Inch equivalent in MM?

In Excel, if you type a "+" before a formula, Excel will automatically convert it to an "=".  I think the "+" may be a throwback to the Dos-based Lotus123 days, but I am probably mistaken.

RE: Inch equivalent in MM?

I use the "+" myself because there is no "=" in the number pad.  Depends where my finger is at the moment...

RE: Inch equivalent in MM?

I didn't know about that convert function.  That will be handy to make the formula's a little more readable.

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?

Or you could create a function. Copy and paste this as a new VB module on a blank spreadsheet (so it will be accessible to every spreadsheet you ever open)


Function in2mm(x As Double) As Double
'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 ... http://www.eng-tips.com/faqs.cfm?pid=731&fid=376

RE: Inch equivalent in MM?

i liked electicpete's were clear result ...

only i'd use number formating to show 3 decimal places ...  what if cam721 wants 1.2" ?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close