Thread: display number as feet and inch in single cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
bigwheel bigwheel is offline
external usenet poster
  
Posts: 222
Default display number as feet and inch in single cell
Or you could use a formula:-

=(TEXT(INT(A1),"0")&"' "&TEXT((A1-INT(A1))*12,"0")&"""")

"covdbrdg" wrote:

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