There is one slight mistake in the above formula...

Thge "*10.0" (times 10) must be changed to "*14.0" (times 14) !!!

OK

FLKulchar
"Bill Kuunders" wrote in message
...
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