In this lesson, we will learn how to convert distance units in Excel.
Suppose we have a number that represents a certain distance, and we want to convert the mathematical unit of distance from one to another.
To convert between distance units, we will follow the following steps:
1- In a new cell, we write the function for converting distance units “CONVERT(=”.
2- We select the cell that contains the number whose unit we will convert the distance.
3- We write a comma “; ” and then write the unit we will convert from, which is here “km”.
4- We write a comma “; ” and then write the unit we will convert to, which is here “m”.
5- We close the bracket and press “Enter” from the keyboard
We can repeat the same process for centimeter:
1- In a new cell, we write the function “CONVERT(=”.
2- We select the cell that contains the number whose unit we will convert the distance.
3- We write a comma “; ” and then write the unit we will convert from, which is here “m”.
4- We write a comma “; ” and then write the unit we will convert to, which is here “cm”.
5- We close the bracket and press “Enter” from the keyboard
Dear reader, if you liked the article, do not forget to subscribe to our YouTube channel, which provides all new in the field of technical and completely free training courses.
You can also browse our website to access the blog and read technical topics, or learn about the training courses offered by the site.
To access the full course “Excel Course” on YouTube, click here.
