The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Message from discussion Pounds and ounces format

From:
To:
Cc:
Followup To:
Subject:
 Validation: For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon.

More options Mar 18 2000, 3:00 am
Newsgroups: microsoft.public.excel.misc
From: "David McRitchie" <DMcRitc...@msn.com>
Date: 2000/03/18
Subject: Re: Pounds and ounces format
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
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...
> 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.

To post a message you must first join this group.