Convert Decimal to Feet and Inches
 

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"

--
Cheers,
Ryan

Convert Decimal to Feet and Inches
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"RyanH" wrote in message
...
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"

--
Cheers,
Ryan

Convert Decimal to Feet and Inches
 

We can come close. For example 7.83333 feet when formatted as:
#?" ft "?/12
displays:
7 ft 10/12
--
Gary''s Student - gsnu200812


"RyanH" wrote:

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"

--
Cheers,
Ryan