From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Converting a value between measurement systems with CONVERT

Converting a value between measurement systems with CONVERT

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Converting a value between measurement systems with CONVERT

“

- If you work with data from different countries, or if you're traveling in different countries, sometimes you need to convert, for example, between kilometers and miles, between Celsius and Fahrenheit, meters and feet. There's a function called convert. It's actually an engineering function in Excel. So imagine you're seeing a sign in Canada or Mexico, or somewhere in Europe. 190 kilometers to the next major city. How many miles is that? Equal, convert, left parenthesis, cell A2 has the number we'd like to convert, comma, and then we see a huge list here. Now if you're new to this, it's going to take you a while to track down some of these, and some are not so obvious. Where's kilometers in here? You won't really find it. Meter, you'll find in here, that's a lowercase m. And you might guess, km, and that's correct. The list to the right in columns G and H, I've pulled this off of the Help system, condensed it a bit, we can see some of the entries right here. So what would we type…

Contents