=INT(A1/14)&"s"&MOD(A1,7)&"lb"

"John Wright" <John wrote in message
...
Hi (from a guy in the UK)

I want to input data of a weight in lb into a cell and then use the data
so
that it converts it to stones and lb.

For instance if i put in 100lb the other cell will say 7s2lb. (100/14=7
remainder2). 14lb in a stone.

How can i do this?