Conversions
 

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.

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

On Mon, 21 Feb 2005 12:55:07 -0800, ICMIII
wrote:

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.

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

-----Original Message-----
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.
.