Chip,

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

10 Stones 5.20000000000002 Pounds

for 66 Kg

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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"

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


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?