WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Convert Function in Excel

Convert Function in Excel

Excel CONVERT Function

Excel CONVERT Function as the word itself says it will convert the number from one measurement system to another measurement system. For example, if we have numbers in meters we can convert them to feet if we have numbers in pounds we can convert to KG if we have numbers in feet we can convert to centimeters and so on.

Below is the syntax of the CONVERT function.

Convert Function in Excel

  • Number: The value that we are trying to convert.
  • From Unit: The current measurement unit of the Number. This argument has plenty of measurement codes; we will see this in a while.
  • To Unit: For which measurement unit, we need to convert the Number.

Measurement has different categories, and each category has different measurement units. Below is the detailed list of the same.

Time Units

Time Units

Speed Units

Speed Units

Force Units

Force Units

Power Units

Power Units

Temperature Units

Temprature Units

Distance Units

Distance Units

Energy Units

Energy Units

Pressure Units

Pressure Units

Weight Units

Weight Units

Above I had given some of the commonly used measurement units. You can go through the function parameters for other measurement units.

How to Convert Units in Excel?

You can download this Convert Function Excel Template here – Convert Function Excel Template

Example #1

Below is the list of fruits and their weight in kilograms. Convert this weight in pounds using excel.

Convert Function - Example 1.1

Copy the above data to excel first. We have fruit weight in “Kilo Grams,” and we need to convert it to “Pounds.”

Step 1: Open CONVERT function

Open the function in cell C2.

Convert Function - Example 1.2

Step 2: Select the number we are trying to convert.

The number that we are trying to convert is B2 cell value, so select the B2 cell as the reference cell.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Convert Function - Example 1.3

Step 3: Specify Current Unit

The second argument is “From Unit” before we convert to some other units, we need to specify what the current unit is. So the current unit is “Kilo Gram,” and from the list, choose “G” as the current unit.

Convert Function - Example 1.4

Step 4: Specify the Unit to be converted into.

The next argument is “To Unit,” so we are trying to convert to “Pounds,” so choose “lbm.”

Convert Function - Example 1.5

Once the arguments are supplied, we need to multiply the value by 1000 to get the result in pounds. So close the bracket and multiply excel it by 1000.

Convert Function - Example 1.6

Step 5: Hit the enter key to get the result.

Convert Function - Example 1.7

Now drag the formula to other cells.

Convert Function - Output 1

Example #2

Below is the height of students in a classroom, and their height is in “Meters,” and we need to convert it to “Inches” using the convert function.

Convert Function - Example 2.1

The meter measurement unit is “m,” and the inches measurement unit is “in.” Apply the same to get the result.

Open the CONVERT function in cell C2, and select cell B2 as this is the number we are trying to convert.

Convert Function - Example 2.2

The second argument is “From Unit” here; we need to specify what the current unit is. So the current unit is “meter” and from the list choose “m” as the current unit.

Convert Function - Example 2.3

The next argument is “To Unit,” we are trying to convert to “Inches,” so choose “in.”

Convert Function - Example 2.4

Now close the bracket and press enter to get the height in inches.

Convert Function - Example 2.5

Drag the formula to below cells.

Convert Function - Output 2

Things to Remember

  • CONVERT function has more measurement units from Excel 2013 onwards.
  • Commonly used measurements are “Weight, Distance, Time, and Travel.”
  • You need to sure of what measurement key you are using.
  • The number argument should always be a numerical value or numerical value cell reference other-wise, we will get #NUM! Error.

Recommended Article

This has been a guide to Convert Function in Excel. Here we discuss how to use the convert function to convert the number from one measurement to another. You can learn more from the following articles –

  • Convert Excel to CSV
  • How to Convert Columns to Rows in Excel?
  • Excel Break-Even Point Examples
  • Group Excel Data
  • Share an Excel Workbook
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Convert Function Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More