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. 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |