Pounds and ounces format

[Ken Schmidt]

I want to display a result in pounds and ounces (rounded off to the nearest
ounce) in the following way: 4 pounds and 2 ounces (4.125 lbs) as 4.2, 4
pounds and 11 ounces (4.6875 lbs) as 4.11. This is what I have so far for
the cell format: #"."?/16 This displays 3.5, for example, as 3.8/16. I
want it to display 3.8. So I have what I want except I need to lose the
"/16". Anyone have any suggestions? TIA. Using XL97 and Win95.

Ken

[David McRitchie]

Hi Ken, (posted to misc with email copy)
Sure looks like it would be confusing, personally I would prefer
something like 4 lb. 2.0 oz.
=INT(17.2)&"lb. "&ROUND(16*MOD(17.2,1),1)&"oz."

Here is 4.2 as requested
=INT(A1)&"." &ROUND(16*MOD(A1,1),0)

Chip Pearson's answer as 4.02 would be to use
=DOLLARFR(A1,16) format as number with 2 decimals
Requires Analysis Toolpak addin
http://www.cpearson.com/excel/fractional.htm

HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://members.aol.com/dmcritchie/excel/excel.htm

Ken Schmidt <ken...@ix.netcom.com> wrote in message
news:8b10hp$b0i$1...@slb1.atl.mindspring.net...

[Ken Schmidt]

Thanks! This does what I wanted.

Ken

David McRitchie <DMcRi...@msn.com> wrote in message
news:ObDF16Sk$GA.248@cpmsnbbsa03...