Home > Formulas > Eng > CONVERT

Excel CONVERT Function Examples

Debra Dalgleish - Contextures

Use the Excel CONVERT function to quickly convert amounts from one measurement system, to a different system. For example, change kilometers to miles, or convert liters to gallons.

convert distance from metric to Imperial

Excel CONVERT Function

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.

convert distance from metric to Imperial

CONVERT Syntax

The CONVERT function has the following syntax for its arguments, with 3 required arguments, and no optional arguments:

  • =CONVERT(number,from_unit, to_unit)

The 3 arguments are:

  • number - the amount you want to convert to a different measurement
  • from_unit - text code for the number's measurement unit
  • to_unit - text code for the converted measurement unit

Note: The text codes are case-sensitive

CONVERTfunction syntax pop-up

Ex 1: Convert Metric to Imperial

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.

  • Note: The text codes are case-sensitive

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”)

convert distance from metric to Imperial

Ex 2: Convert Function Made Easy

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.

CONVERT measurements in Contextures Recipe Calculator

To use the CONVERT worksheet:

  1. First, in the top blue cell, select a conversion type, from the drop down list of unit categories.
  2. Next, in the cell below, enter a number for the quantity or amount.
  3. Then, in the remaining blue cells, choose prefixes and units from the drop down lists.

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.

More CONVERT Examples

If you want to go beyond the basics, take a look at the following CONVERT function examples.

1) Recipe Calculator

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.

select measurement unit from drp down list

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

convert measurements with CONVERT function

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)

convert measurements with CONVERT function

Get the Excel Files ✅

  • CONVERT Function Made Easy -- Click here to download the CONVERT Function Made Easy sample file. Convert amounts from one measurement unit to another, such as feet to metres. The zipped file is in xlsm format, and contains a macro that clears cells when a new category is selected.
  • Excel Calorie Counter with Recipe Calculator -- Go to the Excel Calorie Counter page, to see the details, and several versions of the workbook that you can download.

🐰 Down the Rabbit Hole 🐰

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!

--a) CONVERT Function History

--b) CONVERT Function Limitations

--c) Conversion Formulas

a) CONVERT Function History

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

Excel 2007

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.

CONVERT function syntax pop-up

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

Excel Help for CONVERT Units

Excel 2010

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.

CONVERT function measurement codes list

Excel 2013

The latest update was in Excel 2013, when more categories, codes and prefixes were added for the CONVERT function.

  • The new categories were Area, Information, and Speed
  • There were too many new codes and prefixes to list here.

b) CONVERT Function Limitations

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!

formula coverts 10 kilograms to 0.01 megagrams

c) Conversion Formulas

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.

More Functions

Combine Text/Numbers

Date Functions

Spill Function Examples

 

convert distance from metric to Imperial

VLOOKUP

 

Last updated: September 16, 2025 4:08 PM