Need to convert pounds and ounces to decimal pound. !

March 30, 2012 at 09:24:45
Specs: Windows XP, 3.2GHz / 4 gigs ddr3

I need to change pounds and ounces to decimal pounds in excel.. Example
I am uploading books in spreadsheet which displays in lbs and oz Ex: 8 oz which I need to display as .5 lb My webstore only accepts lb units for weight measurement. Below is a typical series of numbers that have to be all in decimal pound measure
1.59 lbs.
1.4 pounds
1.5 pounds
19.2 oz
22.4 oz
1.6 pounds
1.59 lbs.
2 pounds
2.2 pounds
1.4 pounds

Any help and or assistance in resolving this situation would be greatly appreciated. Pierre

See More: Need to convert pounds and ounces to decimal pound. !

Report •

March 30, 2012 at 09:42:39

You posted the results that you are looking for, but you didn't post the original values, so it's a little tough for us to offer a specific solution/formula.

In general, if you divide the number of ounces by 16, you'll get the decimal equivalent:

8/16 = .5
9/16 = .5625

If you add that to the number of pounds in your source data, you'll have your answer.

Again, unless we know what your source data looks like, we can't offer much else.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question