Excel Convert Function Formula with Examples

What Does It Do ?

This function converts a value measure in one type of unit, to the same value expressed in a different type of unit, such as Inches to Centimetres.

Syntax

=CONVERT(AmountToConvert,UnitToConvertFrom,UnitToConvertTo)

Formatting

No special formatting is needed.

Example

The following table was used by an Import / Exporting company to convert the weight and size of packages from old style UK measuring system to European system.

Abbreviations

This is a list of all the possible abbreviations which can be used to denote measuring systems.

These characters can be used as a prefix to access further units of measure.
Using "c" as a prefix to meters "m" will allow centimetres "cm" to be calculated.