Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Converts a number from one measurement system to another. For example, Convert can translate a table of distances in miles to a table of distances in kilometers.
expression.Convert (Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | The value in from_units to convert. |
| Arg2 | Required | Variant | The units for number. |
| Arg3 | Required | Variant | The units for the result. Convert accepts the following text values (in quotation marks) for from_unit and to_unit, which are listed in the Remarks section. |
Double
| Weight and mass | From_unit or to_unit |
|---|---|
| Gram | "g" |
| Slug | "sg" |
| Pound mass (avoirdupois) | "lbm" |
| U (atomic mass unit) | "u" |
| Ounce mass (avoirdupois) | "ozm" |
| Distance | From_unit or to_unit |
|---|---|
| Meter | "m" |
| Statute mile | "mi" |
| Nautical mile | "Nmi" |
| Inch | "in" |
| Foot | "ft" |
| Yard | "yd" |
| Angstrom | "ang" |
| Pica (1/72 in.) | "Pica" |
| Time | From_unit or to_unit |
|---|---|
| Year | "yr" |
| Day | "day" |
| Hour | "hr" |
| Minute | "mn" |
| Second | "sec" |
| Pressure | From_unit or to_unit |
|---|---|
| Pascal | "Pa" (or "p") |
| Atmosphere | "atm" (or "at") |
| mm of Mercury | "mmHg" |
| Force | From_unit or to_unit |
|---|---|
| Newton | "N" |
| Dyne | "dyn" (or "dy") |
| Pound force | "lbf" |
| Energy | From_unit or to_unit |
|---|---|
| Joule | "J" |
| Erg | "e" |
| Thermodynamic calorie | "c" |
| IT calorie | "cal" |
| Electron volt | "eV" (or "ev") |
| Horsepower-hour | "HPh" (or "hh") |
| Watt-hour | "Wh" (or "wh") |
| Foot-pound | "flb" |
| BTU | "BTU" (or "btu") |
| Power | From_unit or to_unit |
|---|---|
| Horsepower | "HP" (or "h") |
| Watt | "W" (or "w") |
| Magnetism | From_unit or to_unit |
|---|---|
| Tesla | "T" |
| Gauss | "ga" |
| Temperature | From_unit or to_unit |
|---|---|
| Degree Celsius | "C" (or "cel") |
| Degree Fahrenheit | "F" (or "fah") |
| Kelvin | "K" (or "kel") |
| Liquid measure | From_unit or to_unit |
|---|---|
| Teaspoon | "tsp" |
| Tablespoon | "tbs" |
| Fluid ounce | "oz" |
| Cup | "cup" |
| U.S. pint | "pt" (or "us_pt") |
| U.K. pint | "uk_pt" |
| Quart | "qt" |
| Gallon | "gal" |
| Liter | "l" (or "lt") |
The following abbreviated unit prefixes can be prepended to any metric from_unit or to_unit.
| Prefix | Multiplier | Abbreviation |
|---|---|---|
| exa | 1E+18 | "E" |
| peta | 1E+15 | "P" |
| tera | 1E+12 | "T" |
| giga | 1E+09 | "G" |
| mega | 1E+06 | "M" |
| kilo | 1E+03 | "k" |
| hecto | 1E+02 | "h" |
| dekao | 1E+01 | "e" |
| deci | 1E-01 | "d" |
| centi | 1E-02 | "c" |
| milli | 1E-03 | "m" |
| micro | 1E-06 | "u" |
| nano | 1E-09 | "n" |
| pico | 1E-12 | "p" |
| femto | 1E-15 | "f" |
| atto | 1E-18 | "a" |
If the input data types are incorrect, Convert generates an error.
If the unit does not exist, Convert generates an error.
If the unit does not support an abbreviated unit prefix, Convert generates an error.
If the units are in different groups, Convert generates an error.
Unit names and prefixes are case-sensitive.
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.