How to Find Supported Unit Names and Codes for Excel CONVERT Function
Question details
The user wants to find a comprehensive list of unit names and measurement codes supported by the CONVERT function in Excel.

- 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.
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).
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.
Click on a cell and type `=CONVERT(`. The syntax requires a number, a 'from_unit', and a 'to_unit'.
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).
Choose the appropriate code from the dropdown or type it manually wrapped in double quotes, such as "kg" for kilograms or "F" for Fahrenheit.
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.

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. Open WPS Spreadsheet: Launch WPS Office and create a new blank spreadsheet or open your existing Excel file.
- 2. Input your data: Enter the values you wish to convert in a column.
- 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. Press Enter: Hit Enter to execute the formula and drag the fill handle to apply the conversion to other cells.

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.




