Formula to convert lbs into lbs and oz

[dee101]

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

 

[texasalynn]

try this

Excel Workbook
	C
13	2.5
14	2 lb 8 oz
Master

 

[dee101]

Thanks

 

[lenze]

Hers another way

=DOLLARFR(A1,16)

Custom format your cell

# "lb".00 "oz"

This will convert 2.5 to 2.08 and display it as

2 lb. 08 oz

2.8 would be

2 lb. 13 oz

Analysis ToolPak required prior to Excel 2007

lenze

 

[Stanleysteamer101]

Thank you.

 

[Scar]

Hers another way

=DOLLARFR(A1,16)

Custom format your cell

# "lb".00 "oz"

This will convert 2.5 to 2.08 and display it as

2 lb. 08 oz

2.8 would be

2 lb. 13 oz

Analysis ToolPak required prior to Excel 2007

lenze

Thanks