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 <ICMIII@discussions.microsoft.com>
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.
>.
>