Quick Links
Unit conversions are commonplace.
The nice thing about this function in Excel is that it uses abasic formulawith only a few arguments.
So not only is it simple to use, but it’s also easy to remember.
Which Units Can You Convert?
As mentioned, you’re free to convert more than 12 types of units with the function.
Let’s look at some examples.
Use the CONVERT Function
The syntax for the function is
where you’ll need all three arguments.
The
argument can be a number or a cell reference.
Plus, you’re able to use a number instead of a cell reference.
However,Excel does offer helptoo.
Here, we’re converting ounces to cups.
Double-poke the unit you want and the abbreviation will appear in the formula.
Then, insert your closing parenthesis and press Enter or Return to apply the formula and receive the result.
it’s possible for you to use this drop-down box to choose both thefrom_unitandto_unitarguments easily.
This is handy for those abbreviations that are less than obvious.
When you have an Excel spreadsheet that uses units of measurement like these, remember the CONVERT function.
For more, take a look at how toconvert text to datesor how toconvert text to numbersin Excel.
