**Unit conversion** is a common task in our day-to-day lives. In countless situations, you may need to convert decimal feet to feet-inches, and this is where Microsoft Excel excels. With this intention, this article wishes to show you 4 methods of converting decimal feet to feet-inches using Excel.

**Table of Contents**hide

**Download Practice Workbook**

**4 Methods to Convert Decimal Feet to Feet and Inches in Excel**

In order to convert decimal feet to feet-inches, there are 4 methods that you can employ. So, without further ado, let’s see them in action.

Throughout this article, we will use the table below which shows the **Employee Names** and their corresponding** Heights** in *feet*, in this case, our goal is to **convert** the *Height *from *feet *to *feet-inches.*

**1. Using the INT & MOD Functions**

For our first method, we will use the **INT** and **MOD** functions in Excel, so follow these steps.

__Steps:__

- Firstly, select a cell, as an example I have selected the
**D5**cell.

- Secondly, enter this formula in the
**D5**cell to directly convert decimal feet to feet-inches. Conversely, you can copy and paste this formula from here.

` =INT(C5)+(12*MOD(C5,1)>=11.5)&"'"&IF(12*MOD(C5,1)>=11.5,0,ROUND(12*MOD(C5,1),0))&""""`

In this case, the **C5 **cell refers to the *Height* in **decimal feet**. In addition to this, using the **INT **function in conjunction with the **MOD **function is a popular way to convert decimal feet to feet-inches.

- Next, display the results by pressing
**ENTER**. - Finally, use the
**Fill Handle**tool in order to complete the conversion of*Height*in decimal feet to feet-inches.

**Read More: ****How to Convert Feet to Inches in Excel (4 Quick Methods)**

**Similar Readings**

**How to Convert MM to CM in Excel (4 Easy Methods)****Converting CM to Inches in Excel (2 Simple Methods)****How to Convert CM to Feet and Inches in Excel (3 Effective Ways)****Convert Cubic Feet to Cubic Meters in Excel (2 Easy Methods)**

**2. Using ROUNDDOWN Function to Convert Decimal Feet to Feet and Inches in Excel**

Our second method utilizes the **ROUNDDOWN function** in Excel to convert decimal feet to feet-inches. It’s simple & easy so, just follow along.

__Steps 01: Obtain the Feet from the Height__

- To begin, choose a cell, for this example, I have chosen the
**D5**cell. - Next, enter the
**ROUNDDOWN**function and provide the 2 necessary arguments. Here, the**C5**cell refers to the Height in feet while the**0**tells the**ROUNDDOWN**function to display only the integer value.

__Steps 02: Extract Inch from the Height__

- Secondly, choose the
**E5**cell and enter the following expression, which you can copy from here.

`=ROUND((C5-D5)*12,0)`

- Now, click
**ENTER**to get the results.

__Steps 03: Combine Feet & Inch__

- Thirdly, repeat the same process for the
**F5**cell while typing in the following formula.

`=CONCATENATE(D5,"ft"," ",E5,"in")`

- In turn, this links the feet and the inch into a single column.

- Lastly, use the
**Fill Handle**to drag down and fill up the table.

- Eventually, the
*Height*in decimal feet gets converted to feet-inches.

**Read More: ****How to Convert Inches to Feet and Inches in Excel (5 Handy Methods)**

**3. Using INT & TEXT Functions**

The third method uses the **INT **& **TEXT** functions to transform decimal feet to feet-inches therefore, follow these simple steps.

__Steps:__

- To start, select a target cell, for instance, I have chosen the
**D5**cell.

- Secondly, copy and paste this formula and enter it into the
**D5**cell.

`=INT(C5) & " ft " & TEXT(MOD(C5,1)*12, "# ??/16") & "in"`

In the above expression, the **C5** cell represents the Height in feet and the **TEXT** function enables you to format the number.

- Then, press
**ENTER**to show the results and utilize the**Fill Handle**tool to fill out the rows.

**Read More: ****How to Convert Inches to Square Feet in Excel (2 Easy Methods)**

**4. Using IF, ROUNDDOWN, and MOD Functions**

Last but not least, we combine the **IF**, **ROUNDDOWN**, and **MOD **functions to obtain the decimal feet to feet-inches. Therefore, let’s see the process in detail.

__Steps:__

- To begin with, navigate to the
**D5**cell and insert the expression given below.

`=IF(NOT(ISNUMBER(C5)),”n/a”,IF(OR(C5>=1,C5<=-1),ROUNDDOWN(C5,0)&"'-"&TEXT(MROUND(MOD(ABS(C5*12),12),1/16),"0 ##/###")&"""",TEXT(MROUND(ABS(C5*12),1/16)*SIGN(C5),"# ##/###")&""""))`

In this case, the **C5 **cell represents the *Height* in *Feet*.

- Then, use the
**Fill Handle**to copy the formula into the cells below.

Eventually, your results should look like the screenshot shown below.

**Conclusion**

To summarise, this article describes how to convert decimal feet to feet-inches using Microsoft Excel. Make sure to download the practice files & do it yourself. Please inform us in the comment section if you have any queries. We, the **Exceldemy** team, are happy to answer your queries.

## Related Articles

**How to Convert Meters to Miles in Excel (3 Simple Methods)****Convert Meters to Feet in Excel (4 Useful Methods)****How to Convert inch to mm in Excel (3 Simple Methods)****Convert Millimeters (mm) to Inches (in) in Excel (3 Quick Methods)****How to Convert Square Feet to Square Meters in Excel (2 Quick Methods)****Millimeter(mm) to Square Meter Formula in Excel (2 Easy Methods)****Convert Feet to Meters in Excel (4 Simple Methods)**

How would one modify the last option using INT & TEXT to display the fraction in it’s lowest common denominator? Such as 12/16 displays as 3/4?

Hi Kate,

Use MROUND() function, round the number to desired multiple such as 1/2, 1/8, 1/16, 1/32…

with combination TEXT() format function you will get the lowest common denominator.

The text format would look like these:

“# ##/###”

or

“0 ##/###”

Phong

Hello KATE,

Thank you for your question. You can reduce a fraction to its lowest term by specifying the format style of the TEXT function to: =INT(C5) & ” ft ” &TEXT(MOD(C5,1)*12, “000/00”.) & “in”

In general, INT() function is OK for person height conversion as such, positive number.

But in case of measurement, if involve with negative number it become problematic!.

Use ROUNDDOWN() function as you can, down the road it will save you lot of headach.

The formula below will cover whole range of numbers, from negative to positive and round-off to 1/16″

=IF(NOT(ISNUMBER(A1)),”n/a”,IF(OR(A1>=1,A1<=-1),

ROUNDDOWN(A1,0)&"'-"&TEXT(MROUND(MOD(ABS(A1*12),12),1/16),"0 ##/###")&"""",

TEXT(MROUND(ABS(A1*12),1/16)*SIGN(A1),"# ##/###")&""""))

Phong

Hello Phong,

Thank you for your suggestion and for taking the trouble to provide a great solution to Kate’s problem. We, the ExcelDemy team really appreciate your effort and as a result, we’ve updated our article to include the solution that you’ve provided.

Hello Eshrak Kader,

We all learner, I ran to problem before and someone pointed me to right direction, I just hope my little tips could help!

Cheer!

BTW, if you are inerested in VBA, regarding convert to imperal unit in Excel, let me know, I could point you some of my posts.

Phong