How to Convert Decimals to Feet & Inches in Excel

Save

Microsoft Excel does not have any functions that explicitly convert decimals to feet and inches. However, you can use other Excel functions to make the conversion for you. In order to make these connections, you need to remember that there are 12 inches in a foot, so if you have a decimal, you need to convert it to a fraction of 12. For example, if you have 0.5 as your decimal, then as a fraction of 12, you have 6/12, or six inches.

  • Open a new worksheet in Microsoft Excel and type the number with the decimal in cell A1. For example, type 66.9.

  • Type "=INT(A1)" in cell B1. This represents your amount in feet. In the example, cell B1 will display 66.

  • In cell C1, type "=(((A1-INT(A1))12)/10)10." This is the formula to convert your amount in feet to inches. In the example, cell C1 will display 10.8 because 0.9 feet equals 10.8 inches.

References

Promoted By Zergnet

Comments

Resources

  • "Excel 2010 Bible"; John Walkenbach; 2010

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!