View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Try:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
Id there a way to format a number to feet and inches,

i.e 6.25 to display as
6' 3"??
.