any tips on working with feet and inches in excel?

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

Guest

I work in engineering and use many spreadsheets to do alot of work for me.
The problem is that if I'm working with imperial measure, I have to convert
to metric then covert back to imperial. Is there any ways to easily work with
feet and inches that i'm not seeing?
 
Have you thought of entering data in this form 5 2/12 for 5' 2"
You will need to custom format the cells as # ?/12 to prevent Excel changing
the example to 5 1/6
Use the same format for cells where you convert back to US measurements, so
4.75 will show as 4 8/12
Also see Chips stuff at www.cpearson.com
best wishes
 

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
convert column with inches to 2 columns "feet" and "inches" 2
Seperating Feet, inches and fractions 6
How do I change the autoshape size from inches to cm 2
convert decimal inches into feet and inches 4
Excel How To Convert Decimal To Inches 2
Metric conversion formula / function 3
How to format feet/inches (ft'in") 4

Back
Top