Hi,

I'm not sure about a format but with a number of pounds in A1 try this.

=INT(A1*0.0714286)&" St " &INT((A1*0.0714286-INT(A1*0.0714286))/0.0714286)&"
lbs"

It will start losing accuracy at around 2500000 pounds.

Mike


"Odyssey 62" wrote:

How do I format to show lb & stones eg 24lb = 1st 10lb