You could do it with a user defined function e.g.

Function d_to_fi(numberarg As Double)
feet = Int(numberarg)
inches = Format((numberarg - Int(numberarg)) * 12, "#0")
d_to_fi = feet & " ' - " & inches & """"
End Function



"covdbrdg" wrote:

How can I display a number as feet and inch in single cell, ie. 8.5 to
display 8'-6"