convert kilograms to stones AND pounds
=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?
|