any tips on working with feet and inches in excel?

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?
 
B

Bernard Liengme

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

convert column with inches to 2 columns "feet" and "inches" 2
Seperating Feet, inches and fractions 6
convert decimal inches into feet and inches 4
Excel How To Convert Decimal To Inches 2
change decimal to feet and inches 10
Fractions, Feet, Inches, & macros 8
is there a macro that will convert from inches to feet and inches 1
display feet and inches 2

Top