Try the below formula

=(INT(A1/14)&"."&MOD(A1,14))+0

If this post helps click Yes
---------------
Jacob Skaria


"Clive Jones" wrote:

Hello.

I'm trying to find out how to use excel to calculate a number in to weight
(stone and pounds).

What I need it to do is when the lbs gets to 14, then it needs to add 1 to
the stone. I suppose the best way would be to have a seperate stone and lbs
column but I'd like to keep it in one column if possible (as in 00.00).

Any help greatly appreciated.

Thanks :)