Hi, Tom;
" 7 lbs. 2.07812499 ozs. appears to be correct if your original number (the
result of your formula: =$H$5/12*$J$5) is 7.129882811875. To round off your
display, modify Earl's formula as follows (using C20):
=INT(C20) & " lbs " & ROUND(MOD(C20,1)*16,0) & " oz"
This will show the result: 7 lbs 2 oz. I don't know how to do that using a
format either.
Regards,
Ian.