View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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?