Search

Know All About Convert Excel Formula

CONVERT

Learn How to convert type of unit in excel

 

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.
Convert Excel formula Example
Abbreviations
This is a list of all the possible abbreviations which can be used to denote measuring systems.
Convert Formula Abbreviations
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.
Convert Excel formula
Share this article :
Facebook
Twitter
LinkedIn

Leave a Reply