format number in feet and inches

Guest · Feb 23, 2005

Id there a way to format a number to feet and inches, i.e 6.25 to display as
6' 3"??

Jason Morin · Feb 23, 2005

Try:

=INT(A1)&"'-"&ROUND(MOD(A1,1)*12,0)&""""

HTH
Jason
Atlanta, GA

adding feet and inches	6	May 20, 2009
FORMAT FOR FEET AN DINCHES	2	Jan 13, 2010
How to format feet/inches (ft'in")	4	Nov 26, 2007
Convert Ft'-In Fr" (5'-6 3/4") to Ft.dec (5.56)	6	Jul 17, 2009
Conversions of Decimal Feet to Decimal Inches - Formula??	0	Apr 15, 2012
convert column with inches to 2 columns "feet" and "inches"	2	Mar 12, 2010
Excel How To Convert Decimal To Inches	2	Mar 6, 2017
Seperating Feet, inches and fractions	6	Jan 14, 2008

Ask a Question