oops...wrong one....thats stones and pounds.

Check this formula for converting Kilograms to Pounds and Ounces; be sure
you have been to Tools, Add-Ins and checked Analysis Toolpak.

=INT(CONVERT(A2,"kg","lbm"))&" lbs " &INT( MOD(CONVERT(A2,"kg","ozm"),16))&
" oz"http://www.barasch.com/excel/xlFormulas.htm