Thread: Conversions
View Single Post
  #2   Report Post  
Myrna Larson
 
Posts: n/a
Default


=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.