.... and even more interestingly:
11 Stones-1.98951966012828E-13 Pounds for 69.9999999999999 kg :-)
--
David Biddulph

"Sandy Mann" wrote in message
...
Chip,

Would it not be better to ROUND() or TRUNC() the pounds because you
formula returns

10 Stones 5.20000000000002 Pounds

for 66 Kg

"Chip Pearson" wrote in message
...
The following formula will return a string like "10 Stones 5 Pounds"
where cell A2 contains the weight in Kg.

=TRUNC(A2*2.2/14)&" Stones"&A2*2.2-(TRUNC(A2*2.2/14)*14)&" Pounds"

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?