AFAIK, about the nearest you can get with cell formatting alone is 2
8/16lbs, which you can achieve with a custom number format like:
# ?/16lb\s
If a formula in an adjoining cell would do, you could use something like:
=INT(A1)&"lbs "&MOD(A1,1)*16&"oz."
Notice I've used 'oz.' rather than 'ounce' for 1 oz., or 'ounces' for 2 or
more oz. - easier to code.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
