G Guest Sep 6, 2005 #1 I want ot record and then plot weights over a period of time. Will excel "do" stones/pounds??
G Guest Sep 6, 2005 #2 Try this: - =INT(CONVERT(A1,"kg","lbm")/14)&" Stone(s) and "&ROUND(MOD(CONVERT(A1,"kg","lbm"),14),0)&" Pound(s)"
Try this: - =INT(CONVERT(A1,"kg","lbm")/14)&" Stone(s) and "&ROUND(MOD(CONVERT(A1,"kg","lbm"),14),0)&" Pound(s)"