How to Do Feet & Inches in Microsoft Excel

Written by kenrick callwood Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Do Feet & Inches in Microsoft Excel
Microsoft Excel offers a wide variety of useful functions and add-ins to make conversions easier. (number background image by kuhar from Fotolia.com)

Microsoft Excel comes equipped with a "Convert" function that allows users to specify any quantity and have it automatically converted to a different unit of measure. The spreadsheet can easily be configured to automatically convert the values in one column that are expressed in feet into the equivalent amount of inches in another column. However, the program does not support expressions of answers in feet and inches by default. A simple add-in fixes that problem in seconds.

Skill level:
Easy

Other People Are Reading

Things you need

  • Internet connection
  • Microsoft Excel 2000-2007

Show MoreHide

Instructions

  1. 1

    Download the InchCalc add-in file to your hard drive.

  2. 2

    Open Microsoft Excel and load the add-in file. In Excel 2000 and 2003, click "Tools," then "Add-Ins" and click on "Browse." In 2007, click the Office symbol and click "Excel Options," then the "Add-Ins" heading. Click the "Go" button with "Manage Excel Add-Ins" selected, then click "Browse."

  3. 3

    Select the location where the add-in file was downloaded and click "Open."

  4. 4

    Use the new function to convert inches to feet and inches. Put any number into cell A1 and type "=i2s(A1)" without the quotation marks in cell B1. For example, a value of 81 inches (entered 81) in cell A1 will be shown as 6 feet 9 inches (displayed as 6' - 9") in cell B1.

  5. 5

    Use the new function to convert feet and inches to inches. Put any number into cell A2 and type "=s2i(A2)" without the quotation marks in cell B2. For example, a value of 6 feet 11 inches (entered as 6'-11") in cell A2 will be shown as 83 inches (displayed as 83) in cell B2.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.