Inch equivalent in MM? 5

[cam721]

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.

 

[electricpete]

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.

 

[johnwm]

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
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk

 

[PennStateIE]

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.

 

[francesca]

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.

 

[whyun]

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

 

[electricpete]

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.

 

[ColourfulFigsnDiags]

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

 

[rb1957]

i liked electicpete's were clear result ...

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