Jan 13, 2015 · I would like to write a formula in excel, without using macros, to convert decimal feet to feet-inch-sixteenths. Can someone help me ?

Dec 14, 2016 · Re: How do I convert decimal inches to fractions in excel Obtain the correct denominator when working with inches Round up your number to the desired precision: Precision 1/4 = 0.25 1/8 = …

May 14, 2020 · How to show feet inches from decimal? Hello Everyone, I am trying to find this solution for quite long. I am not sure if it's possible. I work a lot with feet and inches dimension in excel. For …

Apr 11, 2016 · Hi! I am working in excel 2003 and I need to convert feet and inches into decimal feet. Example: 15'-10 5/8" to 15.88542 15'-10 5/8" will be in say, column B, and the conversion will be in …

Jun 29, 2022 · Re: Convert Feet and Inches (Fractions) to Decimal Feet Administrative Note: Welcome to the forum. We are happy to help, however whilst you feel your request is similar to this thread, …

Jan 22, 2014 · Convert decimal to 1/16ths I am doing a drawing and when I divide the measurement say 10/ 3, I get a decimal of 3.33. I need to convert that to the nearest 1/16 of an inch. I would like to …

Feb 27, 2020 · I have a spreadsheet which sums dimensions in the FIF Format – Feet, Inches, and Fraction. The fractions are in multiples of sixteens of an inch. The feet, inches, numerator, and …

Mar 7, 2017 · Re: convert decimal to inches If you have 6.11 in A1 try this formula in B1 =DOLLARDE (A1,12)*12 If you want 6 feet 1 inch you need to enter 6.01 to distinguish from 6 feet 10 (6.10) …

Jan 3, 2024 · Convert decimal value to display feet & inches I think the only way to do this is to have two cells/columns. One column where you can enter your decimal feet numbers, and a helper column …

Jun 3, 2025 · Re: Formla helo Decimal Feet to inches If you have 1.9 in A2 as per previous example and you want to show "1 ft 11in" then I'd go back to a formula similar to the one you quoted in your first …