How to Convert Decimal Feet to Feet and Inches in Excel (3 Handy Methods)

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 3 methods of converting decimal feet to feet-inches using Excel.


Download Practice Workbook


3 Methods to Convert Decimal Feet to Feet and Inches in Excel

In order to convert decimal feet to feet-inches, there are 3 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.

Dataset


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.

Using INT & MOD Functions to Convert Decimal Feet to Feet and Inches

  • 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.

Using INT & MOD Functions to Convert Decimal Feet to Feet and 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.

Using INT & MOD FunctionsRead More: How to Convert Feet to Inches in Excel (4 Quick Methods)


Similar Readings


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.

Using ROUNDDOWN Function to Convert Decimal Feet to Feet and Inches

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.

Using ROUNDDOWN Function to Convert Decimal Feet to Feet and Inches

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.

Using ROUNDDOWN Function to Convert Decimal Feet to Feet and Inches

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

Using ROUNDDOWN Function

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

Using ROUNDDOWN FunctionRead More: How to Convert Inches to Feet and Inches in Excel (5 Handy Methods)


3. Using INT & TEXT Functions

The third & final 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.

Using INT & TEXT Functions to Convert Decimal Feet to Feet and Inches

  • 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.

Using INT & TEXT Functions to Convert Decimal Feet to Feet and Inches

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

Using INT & TEXT Functions

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


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

Eshrak Kader

Eshrak Kader

Hello! Welcome to my Profile. I completed my BSc. at Bangladesh University of Engineering & Technology from the Department of Naval Architecture & Marine Engineering. Currently, I am conducting research & posting articles related to Microsoft Excel. I am passionate about research & development and finding innovative solutions to problems.

2 Comments
  1. 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?

    • 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”

Leave a reply

ExcelDemy
Logo