Thread: How to change decimals of length in feet to feet and inchs
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default How to change decimals of length in feet to feet and inchs
If you are talking about showing your conversion in another cell, then you
can use this formula...

=INT(A1)&"'-"&12*MOD(A1,1)&""""

--
Rick (MVP - Excel)


"John" wrote in message
...
For example how to convert 13.25' to 13'-3" ?

Reply With QuoteReply With Quote