Leading the way in Microsoft Office Development

CONVERT(number, from_unit, to_unit)

 -

CONVERT worksheet function

Returns the number in one measurement system converted to another.

This function converts a number in one measurement to the corresponding number in a different measurement.

This function is only available if you have the Analysis ToolPak add-in installed.

Unit Conversions

The following unit abbreviations can be prefixed to any metric "from unit" or "to unit" to automatically convert the units.

Distance

Weight and Mass

Time

Temperature

Force

Pressure

Power

Energy

Liquid

Magnetism