View Single Post
  #26   Report Post  
Brian Canes Brian Canes is offline
Junior Member
 
Posts: 4
Default

Use the =CONVERT(B5,"m","ft")
and format the cell as
#" feet" 0/12 "inches"

So if text is required =TEXT(CONVERT(11.87,"m","ft"),"#"" feet"" ?/12 ""inches""")
will yield
38 feet 11/12 inches

Regards
Brian