Converts a numeric value to a different unit of measure.

Sample Usage



CONVERT(number, from_unit, to_unit)

  • number - The numeric value to convert.
  • from_unit - The unit before conversion.
  • to_unit - The unit after conversion.


CONVERT(2000,"m","km") converts 2000 meters into kilometers, and returns the value 2.
CONVERT(68,"F","C") converts 68 degrees Fahrenheit to Celsius, and returns the value 20.


  • If the unit does not exist, CONVERT returns the #N/A error value.
  • If the units are in different groups, CONVERT returns the #N/A error value.
  • Unit names and prefixes are case-sensitive.
  • The following list outlines the units by category:
    • Weight - u, grain, g, ozm, lbm, stone, sg, cwt, uk_cwt, ton, uk_ton
    • Distance - ang, Picapt, pica, in, ft, yd, m, ell, mi, survey_mi Nmi, ly, parsec
    • Time - sec, min, hr, day, yr
    • Pressure - Pa, mmHg, Torr, psi, atm
    • Force - dyn, pond, N, lbf
    • Energy - eV, e, J, flb, c, cal, BTU, Wh, HPh
    • Power - W, PS, HP
    • Magnetism - ga, T
    • Temperature - C, F, K, Rank, Reau
    • Volume - ang^3, Picapt^3, tsp, tspm, tbs, in^3, oz, cup, pt, uk_pt, qt, l, uk_qt, gal, uk_gal, ft^3, bushel, barrel, yd^3, m^3, MTON, GRT, mi^3, Nmi^3, ly^3
    • Area - ang^2, Picapt^2, in^2, ft^2, yd^2, m^2,ar, Morgen,uk_acre, us_acre, ha, mi^2, Nmi^2, ly^2
    • Information - bit, byte
    • Speed - m/hr, mph, kn, admkn, m/s