Function Problems

How to Find Supported Unit Names and Codes for Excel CONVERT Function

Olivia MillerOlivia Miller Nov 10, 2026 868 views

Question details

The user wants to find a comprehensive list of unit names and measurement codes supported by the CONVERT function in Excel.

How to Find Supported Unit Names and Codes for Excel CONVERT Function
Product
Microsoft Excel
Device & OS
not provided
Scenario
Using the CONVERT formula to change measurements like distance, weight, temperature, or time from one unit to another.
Observed behavior
Needs to input the exact abbreviation strings required by the function to avoid #N/A errors.
Before you start

Make sure you know the exact measurement category (e.g., weight, distance) you are converting, as the CONVERT function requires strict, case-sensitive unit codes (like 'm' for meters or 'lbm' for pound mass).

Solution 1Recommended

Reference Official CONVERT Function Unit Codes

Use Microsoft's official documentation or built-in formula tooltip to find the exact abbreviation for the unit you want to convert.

The CONVERT function syntax is =CONVERT(number, from_unit, to_unit). To make it work, you must use the exact abbreviation codes recognized by the software. These codes are categorized into groups such as Weight and Mass, Distance, Time, Pressure, Force, Energy, Power, Magnetism, Temperature, Volume, and Area.

1
Enter the CONVERT formula

Click on a cell and type `=CONVERT(`. The syntax requires a number, a 'from_unit', and a 'to_unit'.

2
Use the formula auto-complete

After typing the number and a comma, Excel will often display a dropdown list of supported unit codes categorized by type (e.g., Weight and Mass, Distance).

3
Select or type the unit code

Choose the appropriate code from the dropdown or type it manually wrapped in double quotes, such as "kg" for kilograms or "F" for Fahrenheit.

4
Check official documentation

If the dropdown does not appear or you need a less common unit, visit the Microsoft Support page for the CONVERT function to view the complete table of abbreviations.

Reference Official CONVERT Function Unit Codes
Case Sensitivity: Unit codes in the CONVERT function are strictly case-sensitive. For example, 'pt' is a pint, but 'pT' is a pico-Tesla.

Use WPS Spreadsheet for Unit Conversions

WPS Office provides a highly compatible Spreadsheet application that fully supports the CONVERT function and all standard Excel measurement unit codes, completely free.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and create a new blank spreadsheet or open your existing Excel file.
  2. 2. Input your data: Enter the values you wish to convert in a column.
  3. 3. Apply the CONVERT formula: Type `=CONVERT(` and select your data cell. Use the built-in tooltip dropdown to easily pick your 'from' and 'to' measurement codes.
  4. 4. Press Enter: Hit Enter to execute the formula and drag the fill handle to apply the conversion to other cells.
Fully compatible with Microsoft Excel formulas and unit codes.Provides smart formula auto-complete to help you find the right unit abbreviations quickly.Free, lightweight, and easy to use across Windows, Mac, and mobile devices.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my CONVERT function returning an #N/A error?

The #N/A error usually occurs if the unit codes do not belong to the same measurement category (e.g., trying to convert distance to weight) or if the unit abbreviation is misspelled.

Are the unit codes in the CONVERT function case-sensitive?

Yes, the unit codes are strictly case-sensitive. For instance, 'm' stands for meters, while 'M' is not a valid standalone unit code but can be used as a prefix for mega.

Can I use metric prefixes with the CONVERT function?

Yes, you can prepend standard metric prefixes to metric units. For example, adding 'k' (kilo) to 'g' (gram) makes 'kg' (kilogram).

Does the CONVERT function support currency conversions?

No, the CONVERT function is designed for physical measurements like distance, weight, time, and temperature. It does not support live currency exchange rates.