CONVERT Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is one of the commonly applied programs in Windows and Macintosh. It is utilized in saving, arranging and managing data. The program is excellent in creating formula to get result in number form. To easily use Microsoft Excel, different function should be learned and understand. Regarding these functions, one of the common functions used is the Convert function. This is usually utilized for engineering data, measurement, financial and other mathematical computations. Reading this article will give you an introduction about this function.

Convert Function Overview

Convert function change a certain number from one part to another. For instance, convert columns of the weight in kilograms to columns in grams. Convert function is used when there is a certain difficulty that requires a unit different from what is in the given unit. The function is considered as the best means to not compute anymore the data just to obtain the number needed and unit required.

Convert Function Syntax

The formula needs to be keyed in on its cell or formula box:

=CONVERT(number, from_unit, to_unit)


number – is the value from_unit to change

from_unit – the unit of the number to change

to_unit – the required unit

In this Microsoft Excel, user should know the correct abbreviation for the unit to use it easily, for instance meter – m, kilogram – kg, gram – g, milliliters – ml, liters – l and many others.

Important Things to Note

In using the function there are details to familiar one to ensure to get the right result and they are as follows:

  • A #VALUE answer appears once the entered data or formula is not correct.
  • #N/A appears once the unit entered is not read or accepted by the Excel.
  • #N/A also appears if the unit does not assist a truncated unit prefix.
  • #N/Z also comes out if the units cannot be found in diverse groups.
  • Prefixes and unit names are very sensitive so they must be correctly entered. As much as possible before using the program, user must have the list of the unit abbreviation accepted and read by Excel.

How to Use Convert Function

There are two ways on how to utilize convert function. There is a shortcut method and a long process method. Before knowing the two processes, better type in first in cell A1 – 54, cell A2 – kg and cell A3 g. With this data, your converted function is used through following:

Method 1: Long Process

  • From the A4 cell, click the formula tab.
  • Click the arrow down on “Or select a category” and click “Engineering”.
  • From “Select a function” click CONVERT.
  • Click OK.
  • Click the number line and click A1 cell and press enter.
  • Click From_unit and click A2 cell and press enter.
  • Click To_unit and click A3 cell and press enter.
  • Click OK. The answer will appear on A4 cell.

Method 2: Short Process

The Same Given Value

  • Click A4 cell.
  • Type in “=CONVERT (“
  • Click A1 cell and type in “,”
  • Click A2 cell and type in “,”
  • Click A3 cell and type in “,”
  • Press enter tab and the answer automatically appears in A4 cell.

It is up to you to decide which one you think is easier and comfortable to use.

Post comment