Hi, Is there a function or a quick way of coverting kilos into Stones and pounds? Thanks
W Walshy Oct 7, 2006 #1 Hi, Is there a function or a quick way of coverting kilos into Stones and pounds? Thanks
K Kevin James Oct 7, 2006 #2 If the kilos are in cell A1, then this in cell B1 =TEXT(A1/0.453592/14,"00")&" Stone - "&TEXT(MOD(A1/0.453592,14),"00")&" lbs" HTH -- Kevin James. Tua'r Goleuni | Hi, | | Is there a function or a quick way of coverting kilos into Stones and | pounds? | | Thanks | | |
If the kilos are in cell A1, then this in cell B1 =TEXT(A1/0.453592/14,"00")&" Stone - "&TEXT(MOD(A1/0.453592,14),"00")&" lbs" HTH -- Kevin James. Tua'r Goleuni | Hi, | | Is there a function or a quick way of coverting kilos into Stones and | pounds? | | Thanks | | |
