How to Use the CONVERT Function in Microsoft Excel for Engineering and Measurement Units

In global supply chains, international engineering, scientific research, and financial trade, data often arrives measured in diverse dimensional systems (such as metric vs imperial or US customary units). Manually calculating conversion multipliers—such as multiplying pounds by 0.45359237 to get kilograms, or remembering the formula for Fahrenheit to Celsius—invites round-off errors and formula clutter. Microsoft Excel solves this with the built-in CONVERT engineering function.

This tutorial explains the syntax, measurement categories, and standard unit codes supported by the CONVERT function in Microsoft Excel, along with step-by-step practical examples for temperature, distance, weight, and pressure transformations.

Syntax and Rules of the CONVERT Function

The CONVERT function accepts three core arguments:

=CONVERT(number, from_unit, to_unit)

• number: The numeric value you wish to convert. Can be an entered number, cell reference, or evaluated formula.
• from_unit: A text string enclosed in quotation marks representing the source measurement unit (e.g. "mi" for miles, "lbm" for pounds mass, or "C" for Celsius).
• to_unit: A text string enclosed in quotation marks representing the target measurement unit (e.g. "km" for kilometres, "kg" for kilograms, or "F" for Fahrenheit).

Common Measurement Families and Standard Unit Codes

Excel supports dozens of standardized measurement codes across various scientific and technical disciplines:

Measurement Family	Supported Unit Codes	Formula Example
Weight and Mass	"g" (gram), "kg" (kilogram), "lbm" (pound mass), "ozm" (ounce mass), "ton" (metric ton)	=CONVERT(150, "lbm", "kg")
Distance and Length	"m" (metre), "km" (kilometre), "in" (inch), "ft" (foot), "yd" (yard), "mi" (mile), "Nmi" (nautical mile)	=CONVERT(100, "km", "mi")
Temperature	"C" (Celsius), "F" (Fahrenheit), "K" (Kelvin), "Rank" (Rankine)	=CONVERT(98.6, "F", "C")
Pressure	"Pa" (Pascal), "atm" (Atmosphere), "bar" (Bar), "psi" (Pound/sq inch), "mmHg" (Torr)	=CONVERT(32, "psi", "bar")
Energy & Power	"J" (Joule), "e" (Erg), "c" (Thermodynamic calorie), "cal" (IT calorie), "BTU", "HP" (Horsepower), "W" (Watt)	=CONVERT(350, "HP", "W")
Time	"yr" (year), "day" (day), "hr" (hour), "mn" (minute), "sec" (second)	=CONVERT(72, "hr", "day")

Using Standard Metric Prefix Modifiers

For metric measurement units (such as metres, grams, and pascals), you can prepend standard SI metric prefixes directly to the basic unit code:

• "k" (kilo – 1,000): "km" (kilometre), "kg" (kilogram), "kPa" (kilopascal).
• "m" (milli – 0.001): "mm" (millimetre), "mg" (milligram).
• "c" (centi – 0.01): "cm" (centimetre).
• "u" (micro – 0.000001): "um" (micrometre), "ug" (microgram).
• "M" (mega – 1,000,000): "MJ" (megajoule), "MW" (megawatt).

For example, to convert 45,000 centimetres into nautical miles:

=CONVERT(45000, "cm", "Nmi")

Step-by-Step Practical Demonstration: Temperature and Weight Conversions

To construct a dynamic unit conversion calculator in Excel:

1. In cell A2, enter a temperature reading in Fahrenheit: 72.
2. In cell B2, calculate the equivalent Celsius temperature using:

   =CONVERT(A2, "F", "C")

   Excel returns 22.22°C.
3. In cell A3, enter a freight parcel weight in pounds: 250.
4. In cell B3, calculate the equivalent mass in metric kilograms:

   =CONVERT(A3, "lbm", "kg")

   Excel returns 113.40 kg.
5. In cell A4, enter a tyre inflation pressure in PSI: 35.
6. In cell B4, calculate the equivalent pressure in bar:

   =CONVERT(A4, "psi", "bar")

   Excel returns 2.41 bar.

Troubleshooting Common CONVERT Errors

If Excel returns calculation errors, check these common syntax traps:

• #N/A Error (Unit Mismatch or Typo): Occurs if one or both unit codes are spelled incorrectly or if they belong to different measurement families (e.g. "km" and "kg"). Note that unit codes are strictly case-sensitive: for instance, "M" represents the Mega prefix, while "m" represents metre or milli prefix.
• #VALUE! Error: Occurs when the first argument contains non-numeric text strings or invalid dates. Ensure the input cell contains a clean numeric value.
• Autocomplete Prompts: When typing =CONVERT(A2, " into modern Excel, an inline IntelliSense dropdown automatically appears listing every supported unit code, eliminating memorisation requirements.