I'd start at David McRitchie's site
http://mvps.org/dmcritchie/excel/fractex1.htm
From work done by Bernie Deitrick.
Jason Stripling wrote:
I am using the following formula to convert decimal inches into feet and
inches. The problem I have is that the formula is not reducing the fractions.
For instance, when the figure is 35.625 it converts it to 2'-11 10/16"
instead of 2'-11 5/8". I need to keep the inches in 16th's but want the
formula to reduce the fraction when needed. Any suggestions on how to make
this happen?
=INT(F5/12)&"'-"&TEXT(MOD(F5,12),"# ??/16")&""""
--
Dave Peterson