The function is =CONVERT. Number is the value you want to convert. It can be a number held within the same cell as the formula or one referenced in another cell. From_Unit is the unit for the Number. To_Unit is the unit for the result.
Excel requires abbreviations, or short forms, for many measurement units in From_Unit and To_Unit arguments. For example, “in” is used for inches, “m” for meters, “sec” for second, etc. There are several more examples at the bottom of this page. The answer 11.15485564 should appear in cell E4. When you click on cell E4, the complete function =CONVERT(E3, D3, D4) appears in the formula bar above the worksheet. To convert other distances from meters to feet, change the value in cell E3. To convert values using different units, enter the short form of the units in cells D3 and D4 and the value you want to convert in cell E3. You can reduce the number of decimal places displayed in cell E4 to make it easier to read using the Decrease Decimal option available on the Home > Number menu section. Another option for long numbers like this is to use the ROUNDUP function. You can type the short forms directly into the appropriate line in the dialog box, or a cell reference to the location of the short form in the worksheet.
