» Converting Units

Problem:

Column A contains 4 pairs of numbers, which represent kilometers, degrees Celsius, milligrams, and days.
We want to convert the quantities to their equivalents in miles, degrees Fahrenheit, kilograms, and seconds respectively.

Solution:

Use the CONVERT function as shown in the following formulas:

To convert kilometers to miles:
=CONVERT(A2,"km","mi")

To convert Celsius to Fahrenheit:
=CONVERT(A6,"C","F")

To convert milligrams to kilograms:
=CONVERT(A10,"mg","kg")

To convert days to seconds:
=CONVERT(A14,"day","sec")