Convert Decimal to Feet and Inches

's Computer Specifications

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

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:4BA42A11-2873-4A85-B4F2-(E-Mail Removed)...
> 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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert decimal inches into feet and inches	Jason Stripling	Microsoft Excel Misc	2	23rd Apr 2009 02:45 PM
How do I convert decimal to feet and inches	=?Utf-8?B?RXJpaw==?=	Microsoft Excel Worksheet Functions	5	25th Oct 2007 11:54 PM
how do i convert from feet/inches to decimal?	=?Utf-8?B?d2JmaXNoZXI=?=	Microsoft Excel Programming	1	15th Sep 2006 08:38 PM
Convert feet/inches to decimal	=?Utf-8?B?ZGluZ3kxMDE=?=	Microsoft Excel Worksheet Functions	16	21st Feb 2006 10:18 PM
How do i convert feet and inches to a decimal value?	=?Utf-8?B?Z29fY2hyaXNn?=	Microsoft Excel Worksheet Functions	4	22nd May 2005 04:33 PM