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?