The VALUE function in Excel is used to convert numbers that have been entered as text data into numeric values so that the data may be used in calculations. The information in this article applies to Excel versions 2019, 2016, 2013, 2010, and Excel for Mac. Kutools for Excel's Currency Conversion tool brings you a quick way to convert more than 50 currencies in your Excel by using the latest exchange rates from the reliable Internet website. You can easily convert a single value or volume values from a range cells with current exchange rates. Have a Free Trial!
This Excel tutorial explains how to use the Excel CONVERT function with syntax and examples.
Description
The Microsoft Excel CONVERT function will convert a number from one measurement unit to another measurement unit.
The CONVERT function is a built-in function in Excel that is categorized as an Engineering Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the CONVERT function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the CONVERT function in Microsoft Excel is:
Parameters or Arguments
The original units of measure for number. It can be one of the following values:
Value | Measurement Unit | Measurement Type |
---|---|---|
'm' | Meter | Length/Distance |
'mi' | Mile | Length/Distance |
'Nmi' | Nautical mile | Length/Distance |
'in' | Inch | Length/Distance |
'ft' | Foot | Length/Distance |
'yd' | Yard | Length/Distance |
'ang' | Angstrom | Length/Distance |
'pica' | Pica | Length/Distance |
'g' | Gram | Weight/Mass |
'sg' | Slug | Weight/Mass |
'lbm' | Pound | Weight/Mass |
'u' | Atomic unit | Weight/Mass |
'ozm' | Ounce | Weight/Mass |
'yr' | Year | Time |
'day' | Day | Time |
'hr' | Hour | Time |
'mn' | Minute | Time |
'sec' | Second | Time |
'C' or 'cel' | Celsius | Temperature |
'F' or 'fah' | Fahrenheit | Temperature |
'K' or 'kel' | Kelvin | Temperature |
'tsp' | Teaspoon | Liquid Volume |
'tbs' | Tablespoon | Liquid Volume |
'oz' | Fluid ounce | Liquid Volume |
'cup' | Cup | Liquid Volume |
'pt' or 'us_pt' | US pint | Liquid Volume |
'uk_pt' | UK pint | Liquid Volume |
'qt' | Quart | Liquid Volume |
'gal' | Gallon | Liquid Volume |
'l' or 'lt' | Liter | Liquid Volume |
'N' | Newton | Force |
'dyn' or 'dy' | Dyne | Force |
'lbf' | Pound Force | Force |
'Pa' or 'p' | Pascal | Pressure |
'atm' | Atmosphere | Pressure |
'mmHg' | mm of Mercury | Pressure |
'HP' or 'h' | Horsepower | Power |
'W' or 'w' | Watt | Power |
'J' | Joule | Energy |
'e' | Erg | Energy |
'c' | Thermodynamic calorie | Energy |
'cal' | IT calorie | Energy |
'eV' or 'ev' | Electron volt | Energy |
'HPh' or 'hh' | Horsepower-hour | Energy |
'Wh' or 'wh' | Watt-hour | Energy |
'flb' | Foot-pound | Energy |
'BTU' or 'btu' | BTU | Energy |
'T' | Tesla | Magnetism |
'ga' | Gauss | Magnetism |
Returns
The CONVERT function returns a numeric value.
Applies To
- Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007
Example (as Worksheet Function)
Let's look at some Excel CONVERT function examples and explore how to use the CONVERT function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following CONVERT examples would return:
Figure 1. of Currency Conversion in Excel.
In order to convert a Currency to other specified currencies, we can utilize the Excel VLOOKUP Function.
The Excel VLOOKUP Function operates by using various country Currency Codes that we are required to provide.
Generic Formula.
=VLOOKUP(currency,xtable,column,0)*amount
Note – xtable is the range of cells for a second table which specifies the current Currency Exchange Rates.
How to use the Excel Currency Conversion Function.
We can utilize The Excel VLOOKUP Function to help us in converting USD amounts to other currencies by using their currency codes.
We can carry out this operation in the following simple steps!
- Set up your Excel worksheet with the relevant details.
Provide separate columns for the currency symbol and current Currency Conversion Rates. This will be our xtable. See figure below;
- Click on cell D2 in the AMOUNT column and enter the operation syntax provided below in the formula bar of our worksheet.
=VLOOKUP(C2,F2:G7,2,0)*A2
This will convert the amounts located in the USD column into the currency we have indicated the SYMBOL column.
Note – our xtable cell range for this illustration is F2:G7
- Copy the operation syntax into the next cell D3 of the AMOUNT column as displayed below;
Figure 3. of Simple Currency Conversion in Excel.
The Vlookup operation syntax locates the currency in the Excel Table, and then retrieves the current Currency Conversion Rate from column G and converts the USD amount.
The basis of this operation is the VLOOKUP Function.
Figure 4. of Final Result.
Instant Connection to an Expert through our Excelchat Service:
Converting Formulas To Values Using Excel For Mac Pro
Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes