How do I convert ounces to pounds

[Guest]

I am starting with 10 ounces and adding .6 to the following cells. So it starts with 10, next cell is 10.6, next is 11.2 etc. When it gets to 16 ounces I would like to start reading 1 lb 0 ozs, 1 lb 0.6 ozs, etc.
Someone on a message board (don't know if it was this one) gave me the answer about 6 months ago and it worked great. I had my hard drive crash and lost the document (no backup) and am trying to recreate the file.
Any help would be greatly appreciated.
Thanks,
Tracy

 

[Steve Hartman]

=INT(A1/16)&" lbs "&ROUND(MOD(A1,16),1)&" ozs"

Will do it

 

[Guest]

Thanks, that was it. I won't lose it this time. I appreciate your quick response.