Excel’s CONVERT function provides an easy way to display your data in another unit of measurement. For example, if you have a list of temperatures in Fahrenheit and you’d like to add a column that displays each temperature in its Celsius equivalent, you need look no further than the CONVERT function.
Let’s assume your first Fahrenheit temperature, 98.6, is located in cell C7. In cell D7, type =CONVERT(C7,"F","C"), where C7 refers to the temperature you want to convert, “F” refers to Fahrenheit, and “C” refers to Celsius.
Excel allows conversions for dozens of units of measurement, including mass, pressure, distance, magnetism, and many others. Search for the term convert in Excel’s help pages to find an exhaustive list of all conversions and their text values you’ll use in your formula. For example, “m” represents meter, “in” represents inch, “T” represents Tesla, and “ga” represents Gauss.