If the number of feet (3 1/3) is in a1, then =INT(A1) & "'-" & 12*MOD(A1,1) &
""""
will display as you described at the end.
--Bruce

"jkrager" wrote:

Is there any way in excel to display feet and inches? I can get decimal feet
and even fractional feet ie. 3 1/3. Is there any way to multiply the
fraction portion of that by 12 to get it to spit out 4? Even if it ends up
in two differnet cells, I can get another cell to read 3 and the next cell to
read 4, and squash them together to look like 3'-4".