How to calculate pounds and ounces in a chart

M

Michelle K

When entering 6 pounds 12 ounces this shows as a lower value than 6 pounds 3
ounces. How do I make the 12 a higher value than the 3?
 
B

Bernard Liengme

I assume you are entering this a text. To keep the correct order you need
spaces.
6 lbs _3 oz
6 lbs 12 oz
An extra space before the 3, denoted by underscore
If you get to 10 lbs 0 oz, then you should add an extra space before the
number for pounds less than 10
_6 lbs _3 oz
_6 lbs 12 oz
10 lbs _4 oz

Or use real numbers like 6 3/16 and format the cells as ## ??/16
Then you can do math on the values
 

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

Top