Decimal to Feet / Inch Converstion

[savv37]

Hello, I'm trying to convert decimals into feet and inches. I have this formula, =INT(D5) & " ft " & TEXT(MOD(D5,1)*12, "0, #/##") & " in", however, the results are often in fractions that are not common like the 1/32", 1/64", 1/8", 1/4" & 1/2" fractions. Is there a way I can modify this formula so that the fractions are presented in more common construction fractional units?

Regrettably, I'm unable to use the XL2BB. It seems that Excel is preventing the macro from functioning, as the functions are grayed out and cannot be used.

Thanks for taking the time to review & I appreciate all your assistance. Thanks in advance.

 

[Micron]

I think you will have to use a VLookup table as suggested here

Convert Decimal to dimensional fraction VBA?

My initial thought on this is to use a vlookup table with the decimal values, separate columns for numerator/denominator, and build the result as a string: It’s always going to display “slightly small” … but depending on how deep you want to go with the table you’ll be close

community.spiceworks.com

 

[Phuynh]

Don't use "INT" function if you plan to convert negative number to feet-inches, use "ROUNDDOWN" instead.
"ROUNDDOWN" with "MROUND" round the number to 1/64 (or 1/2, 1/4, 1/16, 1/32 etc.), so "TEXT" can
properly formating imperial fraction part (the denominator).

Your original formula has problem with convert negative numbers when using INT(), try this:

=ROUNDDOWN(D5,0) & " ft " & TEXT(MROUND(MOD(ABS(D5),1)*12,1/64), "0 #/##") & " in"

Phh