Excel TV ExcelTV
Excel Functions & Formulas

Convert Function In Excel – Video Tutorial

Updated
Convert Function In Excel

Tired of googling how to convert inches into meters or how many liters a gallon equates to? It is high time to stop being overwhelmed whenever you next face a unit conversion! And Excel is here to help.

Szilvia Juhasz (aka XSzil) is there to teach us the ins and outs of this ‘where-were-you-all-my-life’ function.

Let’s begin.

1- The Convert Function In Excel

Type “=CONVERT(” in any cell you should start seeing the options. First specify the number you want to convert. Then specify the unit of the number. Lastly, specify the unit you want this number to get converted into.

Convert Function In Excel Convert Function In Excel

So, for example, if I want to convert 50 inches into meters, I will use =CONVERT(50,”in”,”m”) to do it.

Note that you do not need to remember that “in” stands for inches or “m” stands for meters. Once you reach the stage of putting in the unit, available options (and their keys) will show up themselves, as given in the picture on the right. So, just select from there.

convert2

2 – Advantages

One feature which makes this function robust is that you cannot convert quantities into anything you like. So, units of area cannot be converted into units of volume. Similarly, units of time cannot be converted into units of distance. Once Excel asks you to input the unit you want to convert a number to, it restricts the options to the units that make sense. So, you do not have to worry about meaningless conversions.

Another advantage, un-insightfully, is the time you save from searching the internet repeatedly for such conversions.

3 – A Disadvantage

One disadvantage is that the list of units does not include the milli’s, the centi’s and the deci’s. For example, you may be able to convert inches into meters. But you have to manually multiply the answer with 100 if you want conversion into centimeters instead.

This might have been done by Microsoft to prevent the list of units from becoming very messy. But, of course, it comes with the assumption that the user knows how to convert, let say, meters to millimeters.

What’s next?

The next time you have to convert quantities or units, remind yourself that Excel is ready and equipped for your needs.

Share this newly discovered function with your friends. Remember, a friend in need is a friend indeed!

Written by

Jamani Arsalan
Jamani Arsalan

Consultant, International Professional Services

  • Project Management
  • Statistical Analysis
  • Health Analytics
I am a consultant, currently based in Middle East, at an international professional services firm. My work largely revolves around project management, and statistical analysis. And my professional interests include developing my knowledge within the discipline of health analytics.

Read more articles by Jamani Arsalan

Editorial standards

Fact Checking & Editorial Guidelines

Every article on Excel TV is held to a published editorial standard. The goal: accurate, current, and useful — without filler.

  1. Expert review. Drafts on technical Excel topics are reviewed by a contributor with hands-on, working knowledge of the feature being covered.
  2. Source validation. Claims about Excel behavior are tested in current Microsoft 365 builds. Third-party product claims are sourced from the vendor's own documentation.
  3. Disclosure. Affiliate links, sponsorships, and any commercial relationships that influenced a piece are disclosed in-line and at the foot of the article.
  4. Updates. Articles are revisited when Microsoft ships changes that affect the content. The most recent revision date is shown on every post.

Spot a problem? Email editor@excel.tv and we will look at it.

Subject-matter review

Reviewed by Subject Matter Experts

Technical Excel articles are reviewed by contributors with verifiable, hands-on experience in the topic — not generalist editors.

  • Qualified reviewers. Reviewers include Microsoft Excel MVPs, working business-intelligence practitioners, and Excel TV editorial staff. See each author's page for credentials.
  • Current to a known Excel build. Procedural articles state which Excel version they were validated against. Where Microsoft has since changed behavior, the article carries an inline update note.
  • Clarity check. Reviewers verify steps are reproducible by a reader at the assumed skill level — not just technically correct in a vacuum.

Want to contribute or review for Excel TV? See the about page.

Comments (3)

Historical comments preserved from the WordPress archive. Commenting is no longer active.

  1. Keith

    Point #3 (Disadvantages) is not quite correct. Or at least not correct in all cases. When you are working with the metric units you can use a huge variety of prefixes to denote the multiples of the units. If you go to the help file associated with the function, you can see the list of prefixes (the list is copied from the help file and listed below).

    Prefix Multiplier Abbreviation
    exa…..1.00E+18….”E”
    peta….1.00E+15….”P”
    tera…..1.00E+12….”T”
    giga….1.00E+09….”G”
    mega..1.00E+06….”M”
    kilo……1.00E+03….”k”
    hecto…1.00E+02….”h”
    dekao..1.00E+01….”e”
    deci…..1.00E-01….”d”
    centi….1.00E-02….”c”
    milli……1.00E-03….”m”
    micro…1.00E-06….”u”
    nano….1.00E-09….”n”
    pico…..1.00E-12….”p”
    femto…1.00E-15….”f”
    atto…..1.00E-18….”a”

    1. Rick Grantham

      Thanks for the clarification Keith. You are correct.