Conversions

I

ICMIII

I need to know how to convert a number with decimals (10.75) to display
in feet and inches (10'-9") in an Excel workbook.
 
J

Jason Morin

If you only need precision to be to the nearest inch,
this should work:

=INT(A1)&"'-"&ROUND(MOD(A1,1)*12,0)&""""

HTH
Jason
Atlanta, GA
 
Top