The Excel CONVERT function is an Engineering function that converts a number between unit systems. You can convert feet into meters, pounds into kilograms, gallons into liters Fahrenheit into Celsius, and so on with this formula. In this guide, we’re going to show you how to use the Excel CONVERT function and also go over some tips and error handling methods.


Supported versions

  • All Excel versions

Excel CONVERT Function Syntax

CONVERT(number, from_unit, to_unit)


Arguments

number The number you want to convert
from_unit The units to convert from *
to_unit The units to convert to *

* Look at the last section for possible values


Examples

Without prefixes

You can include or exclude prefixes like kilo (k) or mega (M) strings in front of units when using the Excel CONVERT function. First, let’s take a look at units without prefixes. All arguments of the CONVERT function are required. Enter a value, its unit, and the target unit information to get the result. One important rule here is using units within the same group. Converting a distance to a weight value doesn’t typically make too much sense.

The following sample shows how to use the Excel CONVERT function to convert a value from feet into meters:

=CONVERT(10,”ft”,”m”) returns 3.05

With prefixes

To use the CONVERT function with prefixes included, add a prefix next to a compatible unit. You will still need to enter a value for all arguments to execute the function. Let’s repeat same example using a prefix. Note that the following formula uses centimeters (cm), instead of meters (m).

=CONVERT(5,”ft”,”cm”) returns 152.40

Download Workbook


Tips

  • Unit names and prefixes are case-sensitive.
  • For a full list of Excel CONVERT function units please see our related page.

Issues

  • If the units are in different groups, the CONVERT function returns the #N/A error value.