How do I convert decimal to feet and inches

E

Erik

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

change feet and inches to decimal inches 4
feet and inches to meters 4
convert meters to feet/inches 21
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
How do I use feet and inches (including fractions of inches) 2
how do i calculate 2' x 4' x 4" 5

Top