Convert Decimal to Feet and Inches

[RyanH]

Is there a magic function that would format a decimal number to feet and
inches? For example,

MAGICFUNCTION(98.8125 inches) = 8'-2 13/16"
or
MAGICFUNCTION(8.234375 feet) = 8'-2 13/16"

 

[Bernard Liengme]

There is no function (magic or otherwise <g>) that can change the format of
a cell
See Chip's notes at:
http://www.cpearson.com/excel/FeetInches.htm
best wishes

 

[Gary''s Student]

We can come close. For example 7.83333 feet when formatted as:
#?" ft "?/12
displays:
7 ft 10/12