View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How do I convert decimal to feet and inches

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"
--
David Biddulph

"Erik" wrote in message
...
I need to know if you can add the fractions in 16ths?

"Toppers" wrote:

or ...

=INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins"


"Erik" wrote:

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.