×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

# Inch equivalent in MM?5

## 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.

### RE: Inch equivalent in MM?

3
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
johnwm
________________________________________________________

Steam Engine enthusiasts: www.essexsteam.co.uk

### RE: Inch equivalent in MM?

You could also use the convert function:
=CONVERT(E6,"in","mm")

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)

#### CODE

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).

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!

### 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.

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!