Excel CONVERT Function

I don’t know about you but I’m forever converting things.

In Australia we use the metric system. Our pounds are kilos, miles are kilometres, inches are centimetres and Fahrenheit is Celsius. If only it was that simple. Unfortunately none of those units convert 1:1.

I know you can Google a conversion but Excel also has an easy function that can convert almost anything.

Including some crazy things I’ve never heard of like slugs (not the garden variety I’m sure), to grams or pounds.

The syntax doesn’t even need translating into English:

=CONVERT(number, from_unit, to_unit)

Simply type in your ‘number,’ and up pops an extensive list of units you can convert.

Excel CONVERT function

Once you make your ‘from_unit’ selection the next list is limited to other units in that group:

Excel CONVERT function

You can find a complete list of units available here.

CONVERT Made Easier

Debra Dalgleish of Contextures has made it even easier and put together a workbook you can download that allows you to select the units from a drop down list.

Why not download it and keep it on your PC for future use.

Now, if only it would convert my whining 4 year old into a happy one…..