|
Home > Formulas > Eng > CONVERT Excel CONVERT Function Examples
|
Use the Excel CONVERT function to quickly convert amounts from one measurement system, to a different system. For example, change pounds to kilograms, or convert meters to miles.

The CONVERT function has the following syntax for its arguments, with 3 required arguments, and no optional arguments:
The 3 arguments are:
Note: The text codes are case-sensitive

With the CONVERT formula, you can change any amount from one measurement system to a different system.
Enter an amount, followed by codes for the two measurement systems.
For example, the following formula will convert 10 litres to gallons.
=CONVERT(10,”lt”,”gal”)
Or, use the 'k' prefix to convert 100 kilometres to miles.
=CONVERT(100,”km”,”mi”)

If you’d like to experiment with the CONVERT function, and all its categories, codes, and prefixes, you can do that in my Easy CONVERT function workbook.
This worksheet, in the screen shot below, shows how each of the CONVERT function's three arguments affect the formula result.

To use the CONVERT worksheet:
Below the blue cells, the green cell shows the result - the amount converted to the selected measurement type. The result is also shown at the top left of the sheet, in bold blue font.
If you want to go beyond the basics, take a look at the following CONVERT function examples.
Some versions of my Excel Calorie Counter have a Recipe Calculator. You can use this tool to add your own recipes to the food list, with nutrition information.
In my workbook, most of the food data is stored in metric measurements. However, your recipes might use the Imperial measurement system.
For example, in the screen shot below, the recipe calls for chicken -- 1.25 pounds.

In the workbooks food lookup table, chicken (100 grams) has 110 calories.

On the Recipe Calculator sheet, shown below, the CONVERT function calculates a multiplier (5.67), in column N.
So, for 1.25 pounds of chicken, the calorie total is 623.69 (110 * 5.67)

In this section, you'll find related Excel tips, shortcuts, skills, and details. These things are nice to know, but not essential, so you can skip this section, and get back to work. Or dive in, for some extra Excel fun and knowledge!
--b) CONVERT Function Limitations
--c) Conversion Formulas
In Excel 2003, and earlier versions, the CONVERT function was part of the Analysis ToolPak. You had to install that, or manually enter a formula to do the conversion mathematics. For example, the following formula would convert a Fahrenheit temperature (in cell B2), to the Celsius equivalent.
=(B2 – 32) * 5/9
If you used CONVERT when it was first added in Excel 2007, the function syntax pop-up didn't show a drop down list of options.

Instead, you had to remember your most-used measurement codes, or go into the Excel Help files, to look them up.

In Excel 2010, the CONVERT function’s data entry options were improved. In that version, when you start to enter the “from_unit” argument, a full list of the measurement codes appeared.
Then, when you start to enter the “to_unit” argument, Excel shows a filtered list of codes, from the measurement category that match your “from_units” selection.
The prefix options aren’t shown though – you have to add them on your own, if you want a prefix.

The latest update was in Excel 2013, when more categories, codes and prefixes were added for the CONVERT function.
Unfortunately, Excel still doesn’t help with CONVERT function prefixes such as “k” (kilo), “M” (mega) and “m” (milli). If you need a prefix, you’ll have to type it in the formula yourself.
For example, in the screen shot below, the formula coverts 10 kilograms "kg", to 0.01 Megagrams "Mg".
Perhaps Microsoft will add that feature to the CONVERT function, sometime in the future!

Instead of using Excel's CONVERT function, you could use formulas to convert amounts from one measurement system to another system.
For example, to convert a Fahrenheit temperature (in cell A2) to Celsius, use this formula:
=(A2 * 9 / 5) +32
There are many more temperature conversion formulas on Wikipedia, as well as a Comparison values chart, for quick comparisons.

Last updated: September 16, 2025 4:08 PM