The CONVERT Function In Excel

Here is a simple way Excel provides to make many common, and some unusual conversions:

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Excel provides a simple function called CONVERT that allows you to convert various units of measure. The syntax for this function is:


Here I have three examples of units that I want to convert:


In cell D3 I can type the formula by entering =CONVERT(C3,

Now I can scroll down through the list and choose the unit of measure to convert from (in this case “F” for Farenheit) and the unit of measure to convert to (“C” for Celcius):


Notice that when selecting the unit of measure to convert to, Excel will filter the list to the more appropriate choices. Once I’ve made my selection, the result then appears:


And the same will work for the other two conversions:


Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply