PC Review


Reply
Thread Tools Rate Thread

Decimal to feet/inch/fractional inch conversion

 
 
Rodney Sergent
Guest
Posts: n/a
 
      11th Aug 2006
Is there a way that a cell can be formatted to convert a decimal of a foot
(2.78') to feet/inches format (2'-9 3/8")?


 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      11th Aug 2006
Take a look at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/fractex1.htm

I'd use formula e3 with a helper cell.

Put 2.78 in B1, put =B1*12 in A1
and the formula in C1.

(I'd be too lazy to convert the formula -- but maybe you're not as lazy as me
<bg>.)


Rodney Sergent wrote:
>
> Is there a way that a cell can be formatted to convert a decimal of a foot
> (2.78') to feet/inches format (2'-9 3/8")?


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to convert decimal feet to feet inch sixteenths =?Utf-8?B?dHY=?= Microsoft Excel Misc 23 20th Feb 2008 10:58 PM
decimal feet to feet-inch-sixteenths conversion =?Utf-8?B?dHY=?= Microsoft Excel Misc 1 7th Mar 2006 07:23 PM
feet/inch to decimal Wes Microsoft Excel Worksheet Functions 3 24th Mar 2004 10:44 PM
Re: Feet, inch, fraction to Decimal conversion Norman Harker Microsoft Excel Worksheet Functions 0 23rd Jul 2003 05:00 PM
Re: Feet, inch, fraction to Decimal conversion EZ Money Microsoft Excel Worksheet Functions 0 23rd Jul 2003 04:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:30 PM.