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

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Michelle K" <Michelle (E-Mail Removed)> wrote in message
news:403A16F9-1A81-4823-933B-(E-Mail Removed)...
> 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?