Thread: formula to convert decimal feet to feet inch sixteenths
View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.misc
buster buster is offline
external usenet poster
  
Posts: 7
Default formula to convert decimal feet to feet inch sixteenths
If you just want feet and inches from a decimal, use this formula:
(decimal in A1)
=INT(A1)&"'-"&TEXT(MOD(A1),1)*12,"#??")&""""
Reply With QuoteReply With Quote