How to Use “CONVERT function” in Microsoft Excel 365? [With Examples]
Tags: convertfunctioninexc, excelfunctions, convertfunction
Published: 2020-08-21 16:50:03

---
title: How to Use “CONVERT function” in Microsoft Excel 365? [With Examples]
published: true
date: 2020-08-14 12:34:28 UTC
tags: CONVERTFunctioninExc,ExcelFunctions,CONVERTFunction,CONVERTFunctioninExc
canonical_url: https://geekexcel.com/how-to-use-convert-function-in-microsoft-excel-365-with-examples/
---

## CONVERT Function in Excel:

In this tutorial, we will discuss the explanation, syntax, and usage of the **CONVERT function in Microsoft Excel 365**.

 

## Explanation of the CONVERT Function:

The **CONVERT**  **function** in Excel 365 **converts a number from one unit type to another unit type**. In other words, it changes one measurement system to another.

- **For example** – a Gram unit can be converted into a Ton unit.

## CONVERT Function – Basic Syntax:

The fundamental syntax of **CONVERT Function** is,

```
=CONVERT(number, from\_unit, to\_unit)
```

### Argument Description:

- **Number (Required) –** The number to be converted from one unit to another unit.
- **From\_unit (Required) –** A text string that indicates the current unit of the given number.
- **To\_unit (Required) –** A text string that indicates the unit for the result.

### Important Note:

- **Unit names and prefixes are case-sensitive.**
- **#VALUE! Error** – CONVERT Function returns this error if the input data types are incorrect.
- **#N/A Error –** CONVERT Function returns this error in the following three scenarios.
  - Two Units are in different groups
  - Units does not exist
  - Units does not support a binary prefix

## Measurement Units:

### **Weight and Mass:**

| **S.No** | **Weight and mass** | **Unit** |
| 1 | Gram | “g” |
| 2 | Slug | “sg” |
| 3 | Pound mass (avoirdupois) | “lbm” |
| 4 | U (atomic mass unit) | “u” |
| 5 | Ounce mass (avoirdupois) | “ozm” |
| 6 | Grain | “grain” |
| 7 | U.S. (short) hundredweight | “cwt” or “shweight” |
| 8 | Imperial hundredweight | “uk\_cwt” or “lcwt” (“hweight”) |
| 9 | Stone | “stone” |
| 10 | Ton | “ton” |
| 11 | Imperial ton | “uk\_ton” or “LTON” (“brton”) |

### **Distance:**

| **S.No** | **Distance** | **Unit** |
| 1 | Meter | “m” |
| 2 | Statute mile | “mi” |
| 3 | Nautical mile | “Nmi” |
| 4 | Inch | “in” |
| 5 | Foot | “ft” |
| 6 | Yard | “yd” |
| 7 | Angstrom | “ang” |
| 8 | Ell | “ell” |
| 9 | Light-year | “ly” |
| 10 | Parsec | “parsec” or “pc” |
| 11 | Pica (1/72 inch) | “Picapt” or “Pica” |
| 12 | Pica (1/6 inch) | “pica” |
| 13 | U.S survey mile (statute mile) | “survey\_mi” |

### **Time:**

| **S.No** | **Time** | **Unit** |
| 1 | Year | “yr” |
| 2 | Day | “day” or “d” |
| 3 | Hour | “hr” |
| 4 | Minute | “mn” or “min” |
| 5 | Second | “sec” or “s” |

### **Pressure:**

| **S.No** | **Pressure** | **Unit** |
| 1 | Pascal | “Pa” (or “p”) |
| 2 | Atmosphere | “atm” (or “at”) |
| 3 | mm of Mercury | “mmHg” |
| 4 | PSI | “psi” |
| 5 | Torr | “Torr” |

### **Force:**

| **S.No** | **Force** | **Unit** |
| 1 | Newton | “N” |
| 2 | Dyne | “dyn” (or “dy”) |
| 3 | Pound force | “lbf” |
| 4 | Pond | “pond” |

### **Energy:**

| **S.No** | **Energy** | **Unit** |
| 1 | Joule | “J” |
| 2 | Erg | “e” |
| 3 | Thermodynamic calorie | “c” |
| 4 | IT calorie | “cal” |
| 5 | Electron volt | “eV” (or “ev”) |
| 6 | Horsepower-hour | “HPh” (or “hh”) |
| 7 | Watt-hour | “Wh” (or “wh”) |
| 8 | Foot-pound | “flb” |
| 9 | BTU | “BTU” (or “btu”) |

### **Power:**

| **S.No** | **Power** | **Unit** |
| 1 | Horsepower | “HP” (or “h”) |
| 2 | Pferdestärke | “PS” |
| 3 | Watt | “W” (or “w”) |

### **Magnetism:**

| **S.No** | **Magnetism** | **Unit** |
| 1 | Tesla | “T” |
| 2 | Gauss | “ga” |

### **Temperature:**

| **S.No** | **Temperature** | **Unit** |
| 1 | Degree Celsius | “C” (or “cel”) |
| 2 | Degree Fahrenheit | “F” (or “fah”) |
| 3 | Kelvin | “K” (or “kel”) |
| 4 | Degrees Rankine | “Rank” |
| 5 | Degrees Réaumur | “Reau” |

### **Volume or Liquid Measure:**

| **S.No** | **Volume or Liquid Measure** | **Unit** |
| 1 | Teaspoon | “tsp” |
| 2 | Modern teaspoon | “tspm” |
| 3 | Tablespoon | “tbs” |
| 4 | Fluid ounce | “oz” |
| 5 | Cup | “cup” |
| 6 | U.S. pint | “pt” (or “us\_pt”) |
| 7 | U.K. pint | “uk\_pt” |
| 8 | Quart | “qt” |
| 9 | Imperial quart (U.K.) | “uk\_qt” |
| 10 | Gallon | “gal” |
| 11 | Imperial gallon (U.K.) | “uk\_gal” |
| 12 | Liter | “l” or “L” (“lt”) |
| 13 | Cubic angstrom | “ang3” or “ang^3” |
| 14 | U.S. oil barrel | “barrel” |
| 15 | U.S. bushel | “bushel” |
| 16 | Cubic feet | “ft3” or “ft^3” |
| 17 | Cubic inch | “in3” or “in^3” |
| 18 | Cubic light-year | “ly3” or “ly^3” |
| 19 | Cubic meter | “m3” or “m^3” |
| 20 | Cubic Mile | “mi3” or “mi^3” |
| 21 | Cubic yard | “yd3” or “yd^3” |
| 22 | Cubic nautical mile | “Nmi3” or “Nmi^3” |
| 23 | Cubic Pica | “Picapt3”, “Picapt^3”, “Pica3” or “Pica^3” |
| 24 | Gross Registered Ton | “GRT” (“regton”) |
| 25 | Measurement ton (freight ton) | “MTON” |

### **Area:**

| **S.No** | **Area** | **Unit** |
| 1 | International acre | “uk\_acre” |
| 2 | U.S. survey/statute acre | “us\_acre” |
| 3 | Square angstrom | “ang2″ or “ang^2” |
| 4 | Are | “ar” |
| 5 | Square feet | “ft2” or “ft^2” |
| 6 | Hectare | “ha” |
| 7 | Square inches | “in2” or “in^2” |
| 8 | Square light-year | “ly2” or “ly^2” |
| 9 | Square meters | “m2” or “m^2” |
| 10 | Morgen | “Morgen” |
| 11 | Square miles | “mi2” or “mi^2” |
| 12 | Square nautical miles | “Nmi2” or “Nmi^2” |
| 13 | Square Pica | “Picapt2”, “Pica2”, “Pica^2” or “Picapt^2” |
| 14 | Square yards | “yd2” or “yd^2” |

### **Information:**

| **S.No** | **Information** | **Unit** |
| 1 | Bit | “bit” |
| 2 | Byte | “byte” |

### **Speed:**

| **S.No** | **Speed** | **Unit** |
| 1 | Admiralty knot | “admkn” |
| 2 | Knot | “kn” |
| 3 | Meters per hour | “m/h” or “m/hr” |
| 4 | Meters per second | “m/s” or “m/sec” |
| 5 | Miles per hour | “mph” |

### **Metric Prefixes:**

| **S.No** | **Prefix** | **Multiplier** | **Abbreviation** |
| 1 | yotta | 1E+24 | “Y” |
| 2 | zetta | 1E+21 | “Z” |
| 3 | exa | 1E+18 | “E” |
| 4 | peta | 1E+15 | “P” |
| 5 | tera | 1E+12 | “T” |
| 6 | giga | 1E+09 | “G” |
| 7 | mega | 1E+06 | “M” |
| 8 | kilo | 1E+03 | “k” |
| 9 | hecto | 1E+02 | “h” |
| 10 | dekao | 1E+01 | “da” or “e” |
| 11 | deci | 1E-01 | “d” |
| 12 | centi | 1E-02 | “c” |
| 13 | milli | 1E-03 | “m” |
| 14 | micro | 1E-06 | “u” |
| 15 | nano | 1E-09 | “n” |
| 16 | pico | 1E-12 | “p” |
| 17 | femto | 1E-15 | “f” |
| 18 | atto | 1E-18 | “a” |
| 19 | zepto | 1E-21 | “z” |
| 20 | yocto | 1E-24 | “y” |

### **Binary Prefixes:**

| **S.No** | **Binary Prefixes** | **Prefix Value** | **Abbreviation** | **Derived from** |
| 1 | yobi | 2^80 | “Yi” | yotta |
| 2 | zebi | 2^70 | “Zi” | zetta |
| 3 | exbi | 2^60 | “Zi” | exa |
| 4 | pebi | 2^50 | “Pi” | peta |
| 5 | tebi | 2^40 | “Ti” | tera |
| 6 | gibi | 2^30 | “Gi” | giga |
| 7 | mebi | 2^20 | “Mi” | mega |
| 8 | kibi | 2^10 | “ki” | kilo |

## Practical Examples of CONVERT Function in Excel 365:

Let’s look at some practical examples of **CONVERT**  **Function**  and explore how to use it in Microsoft Excel.

### **Example 1: Celcius to Fahrenheit Conversion**

- In this example, we are going to convert a number from Celcius to Fahrenheit unit.
- The numbers that are going to be the input for this function are entered in **D5 to D8** cell.
- First, the input in the D5 cell is selected, and then we have to choose the **‘from\_unit’** from the list as Celcius.

![Choose Celsius](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Choose-Celsius.png)<figcaption id="caption-attachment-11773">Choose Celsius</figcaption>

- After that, we have to choose the **‘to\_unit’** from the list as Fahrenheit.

![Choose Fahrenheit](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Choose-Fahrenheit.png)<figcaption id="caption-attachment-11775">Choose Fahrenheit</figcaption>

- Now, the syntax of the **CONVERT function** will look as below.

```
=CONVERT(D5,"C","F")
```

![Celsius to Fahrenheit Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Celcius-to-Fahrenheit-Formula.png)<figcaption id="caption-attachment-11771">Celsius to Fahrenheit Formula</figcaption>

- Click **Enter** to execute the formula.
- Now, the result is returned as output in the **F5** cell.

![Celsius to Fahrenheit Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Celcius-to-Fahrenheit-Output.png)<figcaption id="caption-attachment-11772">Celsius to Fahrenheit Output</figcaption>

- You can repeat the above steps for remaining cells or else you just drag F5 cell to F8 cell so it will return the output instantly.

![Example 1 - Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Example-1-Output.png)<figcaption id="caption-attachment-11776">Example 1 – Output</figcaption>

### **Example 2: Inch to Foot Conversion**

- In this example, we are going to convert a number from Inch to Foot unit.
- The numbers that are going to be the input for this function are entered in **D5 to D7**  cell.
- First, the input in the D5 cell is selected, and then we have to choose the **‘from\_unit’** from the list as Inch.
- After that, we have to choose the **‘to\_unit’** from the list as Feet.
- Now, the syntax of the **CONVERT function**  will look as below.

```
=CONVERT(D5,"in","ft")
```

![Inch to Foot Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Inch-to-Foot-Formula.png)<figcaption id="caption-attachment-11778">Inch to Foot Formula</figcaption>

- Click **Enter** to execute the formula.
- Now, the result is returned as output in the **F5** cell.

![Inch to Foot Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Inch-to-Foot-Output.png)<figcaption id="caption-attachment-11779">Inch to Foot Output</figcaption>

- You can repeat the above steps for remaining cells or else you just drag F5 cell to F7 cell so it will return the output instantly.

![Example 2 - Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Example-2-Output.png)<figcaption id="caption-attachment-11777">Example 2 – Output</figcaption>

## A Brief Summary:

In this short tutorial, we have illustrated how to use the **CONVERT**  **Function**  **in Excel 365** with clear-cut practical examples. Using this function, you can change any number from one unit to another quickly. If you have any **queries/doubts** , kindly share it in the below comment section. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning With Us!!

## Related Articles:

- [How to use the YEARFRAC Function in Microsoft Excel 365?](https://geekexcel.com/how-to-use-yearfrac-function-in-microsoft-excel-365/)
- [How to use the EXACT Function in Microsoft Excel 365?](https://geekexcel.com/how-to-use-exact-function-in-microsoft-excel-365/)