Can I convert Imperial lbs to Stones and lbs in the same cell?

M

Mike H

Hi,

Wity pounds in a1 use this

=INT(A1/14) &" "& MOD(A1,14)

or

=INT(A1/14) &" Stone "& MOD(A1,14)&" Pounds"

Mike
 
Top