decimal feet to feet-inch-sixteenths conversion

T

tv

i am trying to write a formula in excel, without using VB/macros, that will
convert decimal feet to feet-inch-sixteenths. (ex. 4.5417 to 4-6-8)

can anyone help me with this
 
D

Doug Kanter

tv said:
i am trying to write a formula in excel, without using VB/macros, that will
convert decimal feet to feet-inch-sixteenths. (ex. 4.5417 to 4-6-8)

can anyone help me with this
Click to expand...

Several people answered this question when you posted it earlier.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to convert decimal feet to feet inch sixteenths 23
Averaging feet and inches (not decimal feet) 4
How to format feet/inches (ft'in") 4
change decimal to feet and inches 10
Formula converts value into Feet, Inches & Fraction of an Inch 6
display number as feet and inch in single cell 5
Suggestion for new cell formats for Feet and Inch 2
Custom formatting feet and inches from decimal 0

Top