The Excel CONVERT function converts a number from one unit type (eg. Yards) to another unit type (eg. Meters). The function is new to Excel 2007, so is not available in earlier versions of MS Excel.
The format of the function is :
Where the arguments are as follows :
number    The number to be converted 
from_unit    A text string, denoting the current unit for the original number 
from_unit    A text string, denoting the unit that you want to convert the original number to 
The from_unit and to_unit arguments to the Excel Convert function must make sense  ie. they may not be from different measurement types (eg. temperature & distance). If you attempt to convert between two different measurement types, Excel will return the #N/A error.
The tables below show all the different measurement types that the Excel Convert Function can work with, and show the text abbreviations that must be supplied to the function to denote each unit type. Note that the text abbreviations for the unit types are case sensitive.


In addition, the following text can be prepended any metric to_unit or from_unit
(eg. the "c" prepended to the meter unit, "m" becomes "cm" to denote centimeters) :
Multiplier  Multiplier Value  Abbreviation 
exa  1.00E+18  "E" 
peta  1.00E+15  "P" 
tera  1.00E+12  "T" 
giga  1.00E+09  "G" 
mega  1.00E+06  "M" 
kilo  1.00E+03  "k" 
hecto  1.00E+02  "h" 
dekao  1.00E+01  "e" 
deci  1.00E01  "d" 
centi  1.00E02  "c" 
milli  1.00E03  "m" 
micro  1.00E06  "u" 
nano  1.00E09  "n" 
pico  1.00E12  "p" 
femto  1.00E15  "f" 
atto  1.00E18  "a" 
The following spreadsheets show some examples of use of the Excel Convert Function. The spreadsheet on the left shows the format of the function and the spreadsheet on the right shows the results :
Formulas:

Results:
