=ROUNDDOWN(kilos*0.15749,0) & " st " &
ROUNDDOWN((kilos* 35.27 - ROUNDDOWN(kilos * 0.15749,0)*224)/16,0) & " lb " &
ROUNDDOWN(kilos * 35.27 - ROUNDDOWN(kilos *0.15749,0)*224 - ROUNDDOWN((kilos
* 35.27 - ROUNDDOWN(kilos* 0.15749,0)*224)/16,0)*16,2) & " oz"

but do test it thoroughly, I would hate to be responsible for an incorrect
dosage.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"FKBarnett" wrote in message
...
My wife is a dialysis patient at Freeman Hospital, Newcastle, UK and is
more
used to the older units than Kgs. I have been trying to find a formular
that
would convert Kgs to Stns, pounds and ounces with the result looking like,
61.5kg = 9stn 9lbs 10ozs