Formula to divide but leave balance as unit not decimal

[kenh]

I want to convert pounds to stones and pounds e eg 145 lbs = 10 stone 5 pounds not 145 14 =10.357 stones

[karolus]

Hallo

=INT(A2/14) & " stone " & MOD(A2;14) & " pounds"

or alternativly

=INT(CONVERT(A2; "lbm"; "stone")) & " stone " & MOD(A2;14) & " pounds"

or you may simply divide by 14 and use NumberFormat: Fraction…Formatcode: # ??/14
unfortunatly there is no way to hide the Divisor in the View