Thread: Convert decimals to feet / inches in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
  
Posts: 1,120
Default Convert decimals to feet / inches in excel
=TEXT(INT(A1),"0 '")&TEXT(MOD(A1,1)*12,"-0 \""")

--
HTH

Bob Phillips

"rk@morsesteel" wrote in message
...
Can you format a cell to convert decimals to feet & inches
i.e. 10.250 to 10'-3"


Reply With QuoteReply With Quote