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.
Here is 4.2 as requested
Chip Pearson's answer as 4.02 would be to use
Ken Schmidt <ken...@ix.netcom.com> wrote in messagenews:firstname.lastname@example.org...
> 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.
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.