In this Article

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

## 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:

(Notice how the formula inputs appear)

## CONVERT function Syntax and inputs:

1 |
=CONVERT(number,from_unit,to_unit) |

**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.

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

**CONVERT Function – Prefixes**

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

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

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.

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

**CONVERT Function – Area/Volume**

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

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

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

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

**CONVERT Function – Incorrect Data Type**

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

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

**CONVERT** in Google Sheets

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

## 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:

`application.worksheetfunction.convert(number,from_unit,to_unit)`

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