Excel Magic Tricks: Use CONVERT function to convert any measurement units
Learn how to use Excel's CONVERT function to easily switch between different measurement systems. This excel tutorial covers practical excel tips for converting temperatures, weights, and distances. Discover how to perform metric conversions, including fahrenheit to celsius and convert miles to kilometers, making conversion of units simple and efficient in your spreadsheets.
How to convert a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.
Excel Convert Function shortcuts: https://support.microsoft.com/en-us/o...
CONVERT(number, from_unit, to_unit)
Number/cell – The value we wish to convert
From Unit – This is the unit you are converting from
To Unit – This is the unit you are trying to convert to
For example, to convert a value in cell A1 to meters, you can use the formula:
=CONVERT(A1, "ft", "m")