• Home
  • About

Entries RSS | Comments RSS
  • Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

  • Categories

  • Archives

  • Recent Posts

    • Enter Excel Data Without Decimals
    • Entering Dates and Times in Excel
    • Working With Dates In Excel
    • Avoiding Shared Workbooks in Excel
    • David McRitchie’s Excel Pages
  • Pages

    • About
  • Subscribe in a reader

Convert Measurements in Excel

Posted on July 4th, 2008 by Debra Dalgleish

Last weekend I set up a little spreadsheet in Excel to compare the cost of a trip in a rented RV versus a small car. The only gas consumption numbers I could find for the RV were in miles per gallon. Since we use the metric system here in Canada, I needed to convert everything to kilometres and litres.

Fortunately, Excel has a CONVERT worksheet function that makes the conversion easy. The only tricky part is remembering the codes for each type of unit. Most are intuitive, such as ft for foot and g for gram, but a few aren’t, like lbm for pound mass.

To calculate how many litres are in a gallon, I used the formula:
        =CONVERT(1, “gal”,”l”)

In the formula, gal is the code for gallon, and l (lower case L) is the code for litre. And yes, it’s way more expensive to make the trip in an RV.

Share/Save/Bookmark

Filed under: Excel, Travel

« Get to the Point in Twitter Blog vs Web Site »

2 Responses to “Convert Measurements in Excel”


  1. Comment from Alex J
    Time: July 4, 2008, 10:58 am

    The conversion function in Google is even better! Try “convert 33 mpg to liters per 100 Km” in the search line!


  2. Comment from Debra Dalgleish
    Time: July 4, 2008, 8:14 pm

    Nice! Thanks for adding that.
    Debra

Leave a Reply

  • Subscribe

    Subscribe in a reader
  • Email Updates

    Subscribe by Email
  • Calendar

    July 2008
    S M T W T F S
    « Jun   Aug »
     12345
    6789101112
    13141516171819
    20212223242526
    2728293031  
  • Contextures

    • Contextures Excel Pages
    • My Video Tutorials
  • Excel

    • Daily Dose of Excel
    • Excel Team Blog
    • Jan Karel Pieterse
    • JP’s Excel/Outlook
    • PTS Blog
    • Spreadsheet Page Blog
    • TVMCalcs Excel Blog
  • General

    • Hodge Blog
    • J-Walk Blog
    • SuiteMinute