Paul

=INT(A3*0.071249)&" Stones "&ROUND((A3*0.071249-INT(A3*0.071249))*10,1)&" lbs"

OR

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


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 17:34:57 GMT, "Paulf" wrote:

Hope you can help.

Is there a formula that will convert kilos into stones? I have tried the
=CONVERT option, but hoped soneone would be able to show how to display "14
Stones & 4 Lbs" rather than 14.4....

Thanks in advance
Paulf