# CONVERT Function in Excel

## CONVERT Function in Excel

The CONVERT Function in Excel will convert a number in one measurement (Units) system to another.

#### Syntax

`=CONVERT (number, from_unit, to_unit)`

Arguments

• number – The numeric value to convert.
• from_unit – The unit in which the number is.
• to_unit – The units in which the you need to change.

#### Measurement units

The below table shows the measurements and its units

## How to use the CONVERT function in Excel?

Using this function in a Worksheet is simple, all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

To find out the converted value of the given values, Enter the original value in column A and the unit of the value in Column B, and in Column C, enter the unit in which you need to convert the value. Now enter the following formula in Column D

Formula: =CONVERT(A1,B1,C1)

Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the converted value.