hello.

I'm just producing a weight conversion chart in Excel 2007

Is there any way of convert Lbs or Kgs into Stones/lbs?

I.e. to get a value of 12St 12lbs etc

The obvious problem is that if you apply a calculation;

Stones = Lbs / 14 then you get an answer of 12.8, 12.9 etc but can’t get to 13lbs in a stone.

Can this be changed in Excel?

Many thanks

B