decimal feet to feet-inch-sixteenths conversion

G

Guest

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
Conversions of Decimal Feet to Decimal Inches - Formula?? 0
How to format feet/inches (ft'in") 4
change decimal to feet and inches 10
Suggestion for new cell formats for Feet and Inch 2
Formula converts value into Feet, Inches & Fraction of an Inch 6
convert decimal inches into feet and inches 4
How to convert 120608 in Excel into 12 Feet 6 inches 8 sixteenths 12

Top