formula to convert decimal feet to feet inch sixteenths

  • Thread starter Thread starter Guest
  • Start date Start date
Ignore the flaky web interface to the newsgroup, and use a news server.
Outlook Express will do. Try
If it asks for a news server, try msnews.microsoft.com
 
If you just want feet and inches from a decimal, use this formula:
(decimal in A1)
=INT(A1)&"'-"&TEXT(MOD(A1),1)*12,"#??")&""""
 
Been having a nap Buster<g>

This was a March 2007 original which was resurrected by another poster in
November 2007.


Gord Dibben MS Excel MVP
 
Back
Top