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

On Wed, 20 Feb 2008 11:22:04 -0800, Buster
wrote:

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