Googled for this one..........
=INT(A3*0.071429)&" Stones "&ROUND((A3*0.071429-INT(A3*0.071429))*10,0)&"
lbs"
enter the kg's in A3
You can work with the rounding if you need part pounds.
--
Greetings from New Zealand
"Michael Eastwood" <Michael
wrote in
message ...
I tried doing a v lookup for a kg to stone/pound convertion. The problem
arrises because there is 14 lbs to a stone. Excel dosent recoznise 1
stone
12 lbs for example