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\")