Feet and Inches

J

Jason Morin

You can use a custom format of:

# ???/???

or use the options for fractions.

HTH
Jason
Atlanta, GA
 
C

Charlie O'Neill

This is something I picked up form this newsgroup a few months ago.

To create an excel spreadsheet that adds feet (') and inches ("), this work
fine. If A1=3.75 the results are 3'9"

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

Charlie O'Neill
 
Top