# Formula to convert lbs into lbs and oz

This is a discussion on Formula to convert lbs into lbs and oz within the Excel Questions forums, part of the Question Forums category; I have a weight in D8 in pounds, 2.5, how can I convert this into lb. and oz., 2 lb ...

1. ## Formula to convert lbs into lbs and oz

I have a weight in D8 in pounds, 2.5, how can I convert this into lb. and oz., 2 lb 8oz
Using excel 2003
Thanks

2. ## Re: Formula to convert lbs into lbs and oz

try this

Master

 C 13 2.5 14 2 lb 8 oz

 Cell Formula C14 =INT(C13)&" lb "&ROUND(CONVERT(C13-INT(C13),"lbm","ozm"),0)&" oz"

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Thanks

4. ## Re: Formula to convert lbs into lbs and oz

Hers another way
Code:
`=DOLLARFR(A1,16)`
Code:
`# "lb".00 "oz"`
This will convert 2.5 to 2.08 and display it as
Code:
`2 lb. 08 oz`
2.8 would be
Code:
`2 lb. 13 oz`
Analysis ToolPak required prior to Excel 2007

lenze

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•