Convert Inches to Decimal in Microsoft Excel

In this article, we will learn how to convert inches to decimal using Excel as Inches to decimal calculator. An inch is a commonly used term & is the universal unit of measurement. An inch is the name of a unit of length in a number of various systems.

In Excel, we use different conversion to compare results. Here we know the conversion rate from inches to decimal figures.

Inches to Decimal Calculator

1 inch = (1/12) of a foot = 0.083
6 inch = (6/12) of a foot = 0.5
You must have seen this in size chart of school.

We will be using the above-mentioned conversion here..

Let’s take an example as shown below.

pasted image 0 (27)

Here we have values of feet and inches. We will do it step by step as for everyone’s understanding.

Firstly inches will be converted into decimal and then we will add Feet with Feet(inches into decimal) to get Feet(in decimals).

Use the formula in cell C2.

=B2/12

pasted image 0 (28)

Copy the formula in other cells, select the cells taking the first cell where the formula is already applied, use shortcut keys Ctrl + D

pasted image 0 (29)

Now we just have to add Feet with Feet (inches into decimals) using the formula in cell D2

Formula in D2 cell:

=C2+A2

We get the below result.

pasted image 0 (30)

Copy the formula in other cells, select the cells taking the first cell where the formula is already applied, use shortcut keys Ctrl + D
pasted image 0 (31)

As you can see we got our results using the formula.

We can add directly using the formula below.

Formula:

=A2 + (B2/12)

Frequently Asked Question

Q1. How to convert Decimal to Inches?
You can also Feet in decimals to inches in Excel by just multiplying the decimal part with 12, that would be inches.

You can perform these tasks in Excel 2016, 2013 and 2010.

Hope you understood simple addition and division in Excel. Explore more articles on Excel conversion functions here. Please tell us if there’s any doubt in the comment box below. We will definitely help you.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube