Return to List of Excel Functions

CONVERT Function – Convert Units in Excel, VBA, Google Sheets

Download Example Workbook

Download the example workbook

This Tutorial demonstrates how to use the Excel CONVERT Function in Excel to convert a number from one unit to another.

CONVERT Main Function

CONVERT Function Overview

The CONVERT Function Converts a number from one measurement unit to another.

To use the CONVERT Excel Worksheet Function, select a cell and type:

convert formula syntax

(Notice how the formula inputs appear)

CONVERT function Syntax and inputs:


number – Number of units.

from_unit – The original measurement units.

to_unit – The converted measurement units

CONVERT Function 

The CONVERT Function converts a number from a measurement system to another. Say, you want to convert miles into kilometers.

=CONVERT(C3, "km", "mi")

CONVERT Function 01

CONVERT Function – Prefixes

The CONVERT Function can also convert from one prefix to another. 

=CONVERT(C3, "sec", "msec")

CONVERT Function 02

Note: The prefix will proceed the unit in the formula.

CONVERT Function – Binary Prefixes

The CONVERT Function can be used for binary prefixes as well.

=CONVERT(C3, "Mibyte", "Gbyte")

CONVERT Function 03


CONVERT Function – Area/Volume

The CONVERT Function can also convert compound units like meter squared or cubic feet.

=CONVERT(CONVERT(C3, "ft", "mi"), "ft", "mi")

CONVERT Function 04


Alternatively, the units can be directly entered in the formula.

=CONVERT(C3, "ft2", "mi2")

CONVERT Function 05


Easy Excel Automation

Add Excel automation to your workbook with just a few clicks.

Learn More

CONVERT Function – Incorrect Data Type

The CONVERT Function will return an error if the input data type is not the same.

=CONVERT(C3, "g", "hr")

CONVERT Function 06


CONVERT in Google Sheets

The CONVERT Function works exactly the same in Google Sheets as in Excel:

CONVERT Google Function

Additional Notes

Simply enter the number of units, the previous units of measurement, and the desired units of measurement.

CONVERT Examples in VBA

You can also use the CONVERT function in VBA. Type:


For the function arguments (number, etc.), you can either enter them directly into the function, or define variables to use instead.

Return to the List of all Functions in Excel

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions