|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 26th, 2004, 03:12 PM
|
|||
|
|||
convert kilos to STONES and pounds
Hi, i posted earlier asking for conversion to pounds. i
meant to ask for a conversion form kilos to stones and pounds (i.e 15 kilos = 15 stone 2 pounds NOT 15.32) Thanks 
|
|
#2
May 26th, 2004, 03:50 PM
|
|||
|
|||
|
convert kilos to STONES and pounds
With kg in A1 use
=INT(CONVERT(A1,"kg","lbm")/14)&" Stone(s) and "&ROUND(MOD(CONVERT(A1,"kg","lbm"),14),0)&" Pound(s)" -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "kls" wrote in message ... Hi, i posted earlier asking for conversion to pounds. i meant to ask for a conversion form kilos to stones and pounds (i.e 15 kilos = 15 stone 2 pounds NOT 15.32) Thanks
|
|
#3
May 26th, 2004, 03:55 PM
|
|||
|
|||
|
convert kilos to STONES and pounds
=INT(CONVERT(8.8,"kg","lbm")/14)&" stone(s)
"&ROUND(MOD(CONVERT(8.8,"kg","lbm"),14),1)& -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "kls" wrote in message ... Hi, i posted earlier asking for conversion to pounds. i meant to ask for a conversion form kilos to stones and pounds (i.e 15 kilos = 15 stone 2 pounds NOT 15.32) Thanks
|
|
#4
May 26th, 2004, 04:03 PM
|
|||
|
|||
|
convert kilos to STONES and pounds
Thank you!
-----Original Message----- With kg in A1 use =INT(CONVERT(A1,"kg","lbm")/14)&" Stone(s) and "&ROUND(MOD(CONVERT(A1,"kg","lbm"),14),0)&" Pound(s)" -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "kls" wrote in message ... Hi, i posted earlier asking for conversion to pounds. i meant to ask for a conversion form kilos to stones and pounds (i.e 15 kilos = 15 stone 2 pounds NOT 15.32) Thanks .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
