How to use the CONVERT Function in Excel

Add to Favorites
Author: | Edits: don

Use the CONVERT function in Excel to switch between measurements, including distance, temperature, speed, and weight.

This is a great little function and I show you how to use it in its basic version, how to use metric modifiers with it, and also how to use it in combination with VLOOKUP to return values from tables that are in the correct measurement.

Additional Resources

CONVERT Function (msft)

 


Excel Function: CONVERT()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
PI() Function in Excel - Math not Food
Tutorial: How to use the PI() function in Excel for math calculations - it's a pretty cool little f...
How to use Vlookup Across Multiple Worksheets in Excel
Tutorial: This tutorial shows you how to use the Vlookup function across multiple worksheets within ...
Logical Comparison Operators in Excel - How to Compare Things
Tutorial: (Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Logical compariso...
SWITCH() Function in Excel and 3 Alternatives
Tutorial: How to use the SWITCH() function for Excel. SWITCH() allows you to match a series of valu...
How to Use Multiple Functions and Formulas in a Single Cell in Excel
Tutorial: Lets learn how to put multiple functions and formulas in a single cell in Excel in order t...
Easily Input Complex Functions in Excel
Tutorial: In this tutorial I am going to show you how to easily input complex Functions in Excel. To...
Tutorial Details
Excel Function: CONVERT()
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course