Learn Excel - Simplify Life with Excel Concepts

## Excel CONVERT Function

### How to use the CONVERT Function

This Excel tutorial explains how to use the Excel CONVERT function with syntax and examples.

### SUMMARY:

The Excel CONVERT function converts a number from one measurement system(e.g. Yards) to another measurement system(e.g. Meters).

For example,

• The formula =CONVERT(100,"yd","m") would return 91.44 in meters, the function convert 100 from yards to meters unit.
• The formula =CONVERT(22,"C","F") would return 71.6 in Fahrenheit, the function convert 22 from Celsius to Fahrenheit unit.

### PURPOSE:

To convert a number from one measurement unit to another measurement unit.

### RETURN VALUE:

The CONVERT function returns a Number value in the new measurement system.

### SYNTAX:

=CONVERT(number,from_unit,to_unit)

### ARGUMENTS:

The CONVERT function syntax has the following arguments:

• number: Required. The numeric value to convert.
• from_unit: Required. A text string, denoting the current unit for the original number.
• to_unit: Required. A text string, denoting the unit that you want to convert the original number to.
• The CONVERT function accepts the following text values (in quotation marks) for from_unit and to_unit.

### REMARKS:

• The from_unit and to_unit arguments provided to the Excel Convert function must be compatible.
• If the input data types are incorrect, CONVERT returns the #VALUE! error value.
• If the unit does not exist, CONVERT returns the #N/A error value.
• If the unit does not support a binary prefix, CONVERT returns the #N/A error value.
• If the units are in different groups, CONVERT returns the #N/A error value.
• The Unit names and prefixes are case-sensitive.