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.
- All Excel versions
Excel CONVERT Function Syntax
|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
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:
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).
- Unit names and prefixes are case-sensitive.
- For a full list of Excel CONVERT function units please see our related page.
- If the units are in different groups, the CONVERT function returns the #N/A error value.