Feet and Inches

  • Thread starter Thread starter Karl Horberg
  • Start date Start date
You can use a custom format of:

# ???/???

or use the options for fractions.

HTH
Jason
Atlanta, GA
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding feet and inches 6
FORMAT FOR FEET AN DINCHES 2
convert column with inches to 2 columns "feet" and "inches" 2
How to format feet/inches (ft'in") 4
Conversions of Decimal Feet to Decimal Inches - Formula?? 0
Convert Ft'-In Fr" (5'-6 3/4") to Ft.dec (5.56) 6
Seperating Feet, inches and fractions 6
Excel How To Convert Decimal To Inches 2

Back
Top