formula to convert decimal feet to feet inch sixteenths

[David Biddulph]

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

 

[Pete_UK]

One alternative, if you prefer using the internet, is to go through
Google Groups:

http://groups.google.com/group/microsoft.public.excel.misc/?

Hope this helps.

Pete

 

[Buster]

If you just want feet and inches from a decimal, use this formula:
(decimal in A1)
=INT(A1)&"'-"&TEXT(MOD(A1),1)*12,"#??")&""""

 

[Gord Dibben]

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