Can anyone show me how to set up Excel for feet and inches?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I do a lot of my spreadsheet work using the feet and inches, for the
construction industry. Does anyone know of an easy way to set or format the
cells to deal with this?
 
I guess I didn't realize just how difficult it would be. I just need to be
able to present a format and sort it accordingly without making a big deal
out of it. right now I need to use multiple columns. Guess that the best I
can do.
 
muliple columns are best esp if you use feet inches and fractions of an
inch...the dollarde and dollarfr work ok if you use only two of the three
units.Another way is to do all calcs in inches and fractions and convert back
to feet etc at the end
 
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

Conversions of Decimal Feet to Decimal Inches - Formula?? 0
feet and inches to meters 2
Is it possible to display feet and inches in one cell ? 4
Excel How To Convert Decimal To Inches 2
how do i calculate 2' x 4' x 4" 5
How do I convert decimal to feet and inches 5
Is there a formula for inches to feet and inches? 2
Meters to Feet and Inches 2

Back
Top