formula to convert decimal feet to feet inch sixteenths

D

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
 
B

Buster

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

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
 
Top