How to calculate pounds and ounces in a chart

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

Guest

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?
 
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
 
Back
Top