Formulas > =CONVERT()

How To Use CONVERT() Function in Google Sheets


Converts a numeric value to a different unit of measure.

Common Questions about the CONVERT Formula:
• What is the CONVERT formula?
• How is the CONVERT formula used?
• What does the CONVERT formula do?
• What types of data can the CONVERT formula convert?

How can the CONVERT formula be used appropriately?
• Be sure to understand the units of measure you are converting, such as degrees Celsius to Fahrenheit, or ounces to grams.
• Include the source unit and target unit next to the formula itself. This will make it easier to understand and troubleshoot your formula.
• Remember to include the formula's arguments in the right order; the source unit and the target unit must come first in the formula.

How can the CONVERT formula be commonly mistyped?
• Misspelling the formula name (CONVER instead of CONVERT)
• Switching the order of the source unit and the target unit arguments
• Forgetting to add any arguments at all

What are some common ways the CONVERT formula is used inappropriately?
• Trying to convert between measurements that the function is not designed to do, such as millimeters to inches.
• Leaving out necessary components, such as the source unit; this can cause an error.
• Entering incorrect units, such as writing kilometers instead of metres when using metric units; this will change the output of the formula.

What are some common pitfalls when using the CONVERT formula?
• Entering incorrect or inconsistent units; this can result in inaccurate output.
• Forgetting to enter the necessary source and target units; this will cause an error.
• Not including a numerical value in the formula; only a unit can be converted with this formula.

What are common mistakes when using the CONVERT Formula?
• Misunderstanding the purpose of the formula; this can lead to errors or incorrect output.
• Trying to convert to an incompatible unit; the CONVERT formula will only convert units that are compatible.
• Including unnecessary arguments; only two arguments are needed for the formula (the source unit and the target unit).

What are common misconceptions people might have with the CONVERT Formula?
• Thinking the CONVERT formula can convert any type of data; it can only convert units of measure.
• Believing the formula can convert units between systems, such as imperial to metric; the formula is designed to convert within one system only.
• Not understanding what arguments are needed for the formula; only two arguments are needed (the source unit and the target unit).

How To Actually Use CONVERT() in Sheets

CONVERT(value, start_unit, end_unit)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the CONVERT() formula:

How to Convert Fahrenheit to Celsius? In Your Head or in Excel or Google Sheets.

Learn how to convert Fahrenheit to Celsius: the math, calculations in spreadsheets & using CONVERT function, which can be used to convert many other units of measurements in addition to Fahrenheit and Celsius.

Generate a CONVERT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.