another error on my part...change the 10,0 to 14,0
FLKulchar
"Bernard Liengme" wrote in message
...
As an alternative to Bill's answer
A3 has weight in kilograms
=A3*0.071429
then format with Custom format # ??/14
In this way, 100 kg displays as 7 2/14 meaning 7 stone 2 lbs
best wishes from Canada
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"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