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 - 2010,
andrewsexceltips.net
All Rights Reserved.