An improvement to that:
=ROUND(CONVERT(A5,"kg","lbm")/14,0)&" st
"&MOD(ROUND(CONVERT(A5,"kg","lbm"),0),14)&" lb"

My original gave 10st 14 lb for 69.8 kg, for example, whereas my new formula
gives 11st 0 lb.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=INT(CONVERT(A5,"kg","lbm")/14)&" st
"&ROUND(MOD(CONVERT(A5,"kg","lbm"),14),0)&" lb"
--
David Biddulph

"Bristlepete" wrote in message
...
Converting Kilograms to Stones is straight forward but is it possible to
take the part of the number after the decimal point and convert it to
pounds?