How do I convert decimal to feet and inches

G

Guest

I've seen the other posts but they deal with smaller numbers or different
formats. I need to convert 188.76 inches to feet and inches.
 
D

David Biddulph

Yes.

If you want the input in 16ths, just use something like 188 13/16.
If you want the output in 16ths, change the formula from
=INT(A1/12)&" ft "&TEXT(MOD(A1,12),"#.00")&" in" to
=INT(A1/12)&" ft "&TEXT(MOD(A1,12),"# ??/16")&" in"
 

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

Conversions of Decimal Feet to Decimal Inches - Formula?? 0
change feet and inches to decimal inches 4
convert meters to feet/inches 17
Excel How To Convert Decimal To Inches 2
feet and inches to meters 2
Is it possible to display feet and inches in one cell ? 4
Converting measurements 3
Display a number in feet inches and fractions of and inch 1

Top