Here's one I came up with:
INT(RC[-1]*3.2808)&"ft
"&TEXT(MOD(INT(ROUND(RC[-1]*3.2808*12*8,0))/8,12),"# #/#")&"in"
Obviously the initial INT function returns the number of feet. The
inner INT(ROUND()) function rounds to the nearest 1/8 inch, the MOD
function returns the remaing inches after lopping of the number of
feet, and the TEXT function formats the output to show the number of
inches correctly.
--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile:
http://www.excelforum.com/member.php...o&userid=22181
View this thread:
http://www.excelforum.com/showthread...hreadid=479573