# How to Use Excel CONVERT Function?

CONVERT Function in Excel: Excel is a spreadsheet program that is developed for WindowsMacAndroid, and iOS. It helps to perform calculations on your PC. If you want to convert a number in one measurement system to another, then we suggest you use the CONVERT function.

This tutorial will discuss the explanation, syntax, and usage of the CONVERT Function in the Excel spreadsheet. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Explanation of CONVERT Function

• It is one of the built-in functions in Microsoft Excel.
• The CONVERT Function converts a number from one unit type to another unit type. In other words, it changes one measurement system to another.
• For example – we can convert a Gram unit into a Ton unit.

## Syntax

• Here, you will see the syntax of the CONVERT function.
• To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
• Once you enter the formula, click the button to get the result.

=CONVERT(number, from_unit, to_unit)

Argument Description:

• Number – The number to be converted from one unit to another unit.
• From_unit – A text string that indicates the current unit of the given number.
• To_unit – A text string that tells the unit for the result.

Note:
1) Unit names and prefixes are case-sensitive.
2) VALUE! Error – The function returns this error if the input data types are incorrect.
3) If the unit doesn’t exist, does not support a binary prefix, or units are in a different group, it returns #N/A Error.

## Measurement Units

Weight and Mass:

Distance:

Time:

Pressure:

Force:

Energy:

Power:

Magnetism:

Temperature:

Volume or Liquid Measure:

Area:

Information:

Speed:

Metric Prefixes:

Binary Prefixes:

## Examples

Let’s look at some practical examples of the CONVERT Function and explore using it in Excel.

• Initially, you have to open your Excel workbook on your PC and launch the worksheet with data.
• For instance, we have given the Celsius in cell B2 and we want to convert it to Fahrenheit unit using the CONVERT function.
• Then, you have to enter the formula in the cell as shown below to get the result.
• After entering the formula, you need to click the  button to get the output.

## Input that Causes Error

• The function returns this error if the input data types are incorrect.