# How to calculate pounds and ounces in a chart

=?Utf-8?B?TWljaGVsbGUgSw==?=
Guest
Posts: n/a

 23rd Nov 2004
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?

Bernard Liengme
Guest
Posts: n/a

 23rd Nov 2004
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

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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Quin Microsoft Excel Misc 5 8th Apr 2010 10:43 PM BCraft Microsoft Excel Misc 4 14th Jan 2010 10:43 PM Carole Microsoft Excel Discussion 4 1st Mar 2005 09:49 PM =?Utf-8?B?QWdvb2dpcmw=?= Microsoft Excel Misc 3 5th Jan 2005 11:00 PM 1fishy Microsoft Excel Misc 9 6th Apr 2004 04:23 AM

Features