Convert to Feet & Inches
Enter number in A1, then use this formula in any other cell
=TEXT(INT(A1/12),"#,##0")&"' "&MOD(A1,12)&""""
© Copyright 2004 - 2007,
andrewsexceltips.com
. All Rights Reserved.