View Single Post
  #9  
Old February 18th, 2005, 09:32 PM
simon
external usenet poster
 
Posts: n/a
Default

Where cell A1 contains a numeric value in kg, for the stones part use:
In one cell
=INT(CONVERT(A1,"kg","lbm")/14)


for the remainder in pounds:
in another cell

=MOD(CONVERT(A1,"kg","lbm"),14)