convert kilograms to stones AND pounds
Hi
If you have a kilo weight in A1 then essentially your formula is:
=A1*2.2/14
to convert to Stones.
Apply a custom format of:
0 ?/14
will then give yo a return like:
10 5/14
meaning 10 stones, 5 pounds.
This what you wanted?
Richard
--
Richard Schollar
Microsoft MVP - Excel
"Bristlepete" wrote in message
...
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?
|