To replace commas to dots or any other symbol that you use as a decimal point separator in the Excel spreadsheet, do the following: 1. To change the global settings for using commas instead of decimal points and vice versa, see Change the decimal point to a comma or vice versa in Excel. If you look at a decimal equivalent chart, you'll notice that the first two digits are different for every single fraction up to the 32nds. Normally, drills are given in 4ths, 8ths, 16ths and 32nds. Most of the time the value you get won't be exactly the decimal equivalent of the fractional size of the drill, so you have to approximate. So if you are using an earlier version of Excel, then you need to come up with an alternative function. NUMBERVALUE() is a new function added in Excel 2013. How to convert European number formats in earlier versions of Excel. is the group separator in European format, NUMBERVALUE() returns 1433502.5. Inches - Fractional to Decimal Equivalents - Decimal equivalents of eights, sixteenths, thirty-seconds and sixty-fourths of an inch Length Units Converter - Convert between common length units like meters, feet, inches, nautical miles and more Pipe Fractional Equivalents - Comparing pipe fractions and decimal inches Most of the time the value you get won't be exactly the decimal equivalent of the fractional size of the drill, so you have to approximate. This step is dependent on the version of Excel. Uncheck Automatically insert a decimal point. Excel 2010/2013 - Go to File -> Options Excel 2007 - Go to Office Button -> Excel Options Select Advanced in the left hand column. This step is dependent on the version of Excel you are using.

Utm to decimal degrees converter excel