# Converting Millimeters to Fractions

 Forum topic by CharlieM1958 posted 07-18-2008 08:44 PM 48563 views 10 times favorited 107 replies
 CharlieM195816274 posts in 4212 days 07-18-2008 08:44 PM Okay, so it’s a slow day at work, but this has been a pet peeve of mine. I often run across a measurement given in millimeters, and wish I had a handy reference to convert that number into fractional inches. There are a lot of charts and calculators online that will give you decimal equivalents, but nothing I could find that will quickly tell me that 17mm equals pretty close to 11/16ths. So I used my Excel skills and some free time to come up with my own. You can get it here: http://www.loyno.edu/~cbmarsh/mmtofraction.htm I have included columns to get you to the nearest 16th, 32nd, or 64th, depending on how precise you care to get. The PDF version will be easiiest for most of you, but I’ve included a link to the Excel file as well, in case you want to monkey around and modify it to best suit your own needs. -- Charlie M. "Woodworking - patience = firewood"

## 107 replies so far

 Russel2199 posts in 3933 days #1 posted 07-18-2008 08:50 PM Very cool. Thanks. -- Working at Woodworking http://www.VillageLaneFurniture.com lew12052 posts in 3749 days #2 posted 07-18-2008 08:57 PM Thanks, Charlie! This will be great laminated and hanging in the shop. Lew -- Lew- Time traveler. Purveyor of the Universe's finest custom rolling pins. PurpLev8535 posts in 3642 days #3 posted 07-18-2008 09:35 PM Thanx! a good reference to keep around….. now if everyone would only work in metric…. we wouldn’t have these problems to begin with would we? lol… sorry, but metric just makes sense, and working in fractions is a pain in the a\$\$ sometimes. -- ㊍ When in doubt - There is no doubt - Go the safer route. Karson35120 posts in 4394 days #4 posted 07-18-2008 09:40 PM Thanks Charlie. Print out nice on the color laser. -- I've been blessed with a father who liked to tinker in wood, and a wife who lets me tinker in wood. Southern Delaware soon moving to Virginia karsonwm@gmail.com † CharlieM195816274 posts in 4212 days #5 posted 07-18-2008 09:41 PM I couldn’t agree with you more. But the old inches and fractions system just wont die. If I’m not mistaken, it was something like 30-40 years ago when it was officially announced that the U.S. would be going to the metric system. I guess the wheels of progress turn slowly, huh? :-) -- Charlie M. "Woodworking - patience = firewood" Bob N131 posts in 3921 days #6 posted 07-18-2008 09:55 PM Charlie, I really apprciate your sharing this with us. This will come in soooo handy! SteveKorz2134 posts in 3708 days #7 posted 07-18-2008 09:57 PM That’s pretty handy… looks like a good reference to put in the shop… Thanks Charlie! -- As iron sharpens iron, so one man sharpens another. (Proverbs 27:17) † Greg Wurst794 posts in 3826 days #8 posted 07-18-2008 10:23 PM That’s going in the shop. Thanks for the effort! -- You're a unique and special person, just like everyone else. MrWoody321 posts in 3768 days #9 posted 07-18-2008 10:49 PM I definitely appreciate your work on this but I won’t be using it. sorry. Canada had the metric system forced on us a number of years back and one thing I have learned in that time is to never convert.If it’s in imperial measure use imperial. If it’s in metric use metric. The cost of appropiate measuring instruments is very low compared with the aggravation and inaccuracy of converting. Just the opinion of one ticked Canadian. It wasn’t broken and didn’t need fixing. -- If we learn from our mistakes, I'm getting a fantastic education. CharlieM195816274 posts in 4212 days #10 posted 07-18-2008 10:54 PM LOL, MrWoody! I’ll try not to take it personally. :-) -- Charlie M. "Woodworking - patience = firewood" GMman3902 posts in 3691 days #11 posted 07-18-2008 11:08 PM I know what you mean I have sliding ruler that works well but get yourself a tape measure with both English on top and Metric at the bottom Zuki1404 posts in 4071 days #12 posted 07-19-2008 12:39 AM Thanks Charlie. I use both out in the shop. At time I find that metric is more accurate. The chart is super. Rob 216 posts in 3662 days #13 posted 07-19-2008 01:02 AM It prints well in good ole b&w too. Thanks Charlie, great idea. Callum Kendall1918 posts in 3697 days #14 posted 07-19-2008 01:03 AM Thanks Charlie, I am lucky, I have a built in converter on my cell phone:) Callum -- For wood working podcasts with a twist check out http://thetimberkid.com/ Douglas Bordner4024 posts in 4058 days #15 posted 07-19-2008 04:09 AM Thanks, Charlie. Powerful tool, that Excel. One of the best things Bill Gates ever sprang on us (I recall trying to use Lotus123 with a great deal of wailing and gnashing of teeth). -- "Bordnerizing" perfectly good lumber for over a decade.

showing 1 through 15 of 107 replies