SkipVought,
I need the fee-inches to be displayed as #'-#". Do you know of a formula which can take this and convert to strictly inches or feet.
I know the formula to convert 5.75 to 5'-9" (see below), but was not able to do the reverse.
=INT(A2)&"'-"&TRIM(TEXT(ROUND(MOD(A2,1)*12*16,0)/16,"#...