Gord,

=INT(A3*0.071429)&" Stones "&ROUND((A3*0.071429-INT(A3*0.071429))*10,0)&"
lbs"

Should you not have multiplied by 14 instead of 10? (Unless of course
Canada has metric stones <g)

and would it not be better to divide by 14 then multiply by 0.071429?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
This formula will give you stones and pounds from Kg

=INT(A3*0.071429)&" Stones "&ROUND((A3*0.071429-INT(A3*0.071429))*10,0)&"
lbs"


Gord Dibben MS Excel MVP


On Mon, 27 Oct 2008 15:44:01 -0700, Bristlepete
wrote:

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?