Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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")&"""" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert inches & display as Feet Inches and Fractions -- BUG FREE | Excel Worksheet Functions | |||
How do I convert decimal to feet and inches | Excel Worksheet Functions | |||
Converting from feet, inches and fractions to inches and decimal p | Setting up and Configuration of Excel | |||
Convert feet/inches to decimal | Excel Worksheet Functions | |||
How do i convert feet and inches to a decimal value? | Excel Worksheet Functions |