The Excel CONVERT function

Most conversions are easily done

If you need to convert between different measurement systems Excel has just the function for you, called CONVERT.

In the image below there are some examples using common conversions.

Syntax

CONVERT(number, from_unit, to_unit)

number – a value or a link to a cell that has a value to be converted.

from_unit – the text code the represents the unit to converts from. If entered in the formula the text must be enclosed in quotation marks. You can link to a cell with the text in it as per the examples above.

to_unit – the text code the represents the unit to convert to. If entered in the formula the text must be enclosed in quotation marks. You can link to a cell with the text in it as per the examples

If you try to convert measures that are in a different measurement group an #N/A error is displayed eg kg (kilograms) to in (inches).

In the example, which you can download at the button below, I have included lists of the different groups of codes you can use for each measure.

Download example file

Note: some measures have separate codes for liquid (oz = fluid ounce) and mass (ozm = weight).

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.