Decimal Numbers to Feet and Inches

[kimcoloprecast]

Is there a way to store a text style that will allow me to convert decimal numbers into feet and inches in the same cell?

I want to be able to type in a number like 3.5 and have it read 3'-6".

Thanks.

 

[CaptnExcitement]

This formula will also convert an entry from a number and decimal to Feet and Inches. However it must be in an adjacent cell.

3.50 3 Feet 6 Inches

=INT(A12)&" Feet"&" "&CONVERT(A12-INT(A12),"ft","in")&" Inches"

or

3.50 3 ' 6 "

=INT(A12)&" '"&" "&CONVERT(A12-INT(A12),"ft","in")&" """

Is there any way to make this display only 2 decimal places?