If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




convert decimal inches into feet and inches
I am using the following formula to convert decimal inches into feet and
inches. The problem I have is that the formula is not reducing the fractions. For instance, when the figure is 35.625 it converts it to 2'11 10/16" instead of 2'11 5/8". I need to keep the inches in 16th's but want the formula to reduce the fraction when needed. Any suggestions on how to make this happen? =INT(F5/12)&"'"&TEXT(MOD(F5,12),"# ??/16")&"""" 
Ads 
#2




convert decimal inches into feet and inches
I'd start at David McRitchie's site
http://mvps.org/dmcritchie/excel/fractex1.htm From work done by Bernie Deitrick. Jason Stripling wrote: > > I am using the following formula to convert decimal inches into feet and > inches. The problem I have is that the formula is not reducing the fractions. > For instance, when the figure is 35.625 it converts it to 2'11 10/16" > instead of 2'11 5/8". I need to keep the inches in 16th's but want the > formula to reduce the fraction when needed. Any suggestions on how to make > this happen? > > =INT(F5/12)&"'"&TEXT(MOD(F5,12),"# ??/16")&""""  Dave Peterson 
#3




convert decimal inches into feet and inches
I actual dug a little deeper yesterday and found out how to do it. The
formula is shown below. =INT(F5/12)&"'"&TEXT(MOD(F5,12),"# ??/??")&"""" The only issue I have with this one is that it has extra spaces in the final numbers when you don't have four numbers for the fraction. For instance, 2'11 5/8" is actually 2'11 5/8 ". It replaces the missing ?, from the formula, with a space. This is close enough for me. If anyone knows how to fix it though, let me know. "Dave Peterson" wrote: > I'd start at David McRitchie's site > http://mvps.org/dmcritchie/excel/fractex1.htm > > From work done by Bernie Deitrick. > > Jason Stripling wrote: > > > > I am using the following formula to convert decimal inches into feet and > > inches. The problem I have is that the formula is not reducing the fractions. > > For instance, when the figure is 35.625 it converts it to 2'11 10/16" > > instead of 2'11 5/8". I need to keep the inches in 16th's but want the > > formula to reduce the fraction when needed. Any suggestions on how to make > > this happen? > > > > =INT(F5/12)&"'"&TEXT(MOD(F5,12),"# ??/16")&"""" > >  > > Dave Peterson > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Convert inches & display as Feet Inches and Fractions  BUG FREE  Mark Main  Excel Worksheet Functions  12  November 26th 08 09:50 PM 
How do I convert decimal to feet and inches  Erik  Excel Worksheet Functions  5  October 25th 07 11:54 PM 
Converting from feet, inches and fractions to inches and decimal p  Dee  Setting up and Configuration of Excel  5  September 18th 07 04:18 PM 
Convert feet/inches to decimal  dingy101  Excel Worksheet Functions  16  February 21st 06 11:18 PM 
How do i convert feet and inches to a decimal value?  go_chrisg  Excel Worksheet Functions  4  May 22nd 05 04:33 PM 