Convert Kilo's to pounds and ounces

Hi, is there a formula to convert kilo's into pounds? i
can convert simply multiplying the kilos by 2.2 and
dividing by 16, but this gives me 'decimal' answer (i.e
instead of 93 kilos returning 12 stone 12 ounces, it
returns 12.75) - Thanks

Have a look in HELP index for CONVERT.

--
Don Guillett
SalesAid Software

"kls" wrote in message
...
Hi, is there a formula to convert kilo's into pounds? i
can convert simply multiplying the kilos by 2.2 and
dividing by 16, but this gives me 'decimal' answer (i.e
instead of 93 kilos returning 12 stone 12 ounces, it
returns 12.75) - Thanks

Thanks, but this only converts from kilos to lbs or
ounces. i wanted to convert from kilos to stones and
pounds. Any more help?

thanks.


-----Original Message-----
Have a look in HELP index for CONVERT.

--
Don Guillett
SalesAid Software

"kls" wrote in
message
...
Hi, is there a formula to convert kilo's into pounds? i
can convert simply multiplying the kilos by 2.2 and
dividing by 16, but this gives me 'decimal' answer (i.e
instead of 93 kilos returning 12 stone 12 ounces, it
returns 12.75) - Thanks


.

Hi

Use kg for the from unit
Use lbm for the to unit

That gives the result in lbs.

To get stones you divide the result by 14.

If you want stones and pounds then you can use something like:

=INT(CONVERT(A1,"kg","lbm")/14)&" stones
"&MOD(CONVERT(A1,"kg","lbm")/14,1)*14&" pounds"

or:

=CONVERT(A1,"kg","lbm")/14
format: # ?/14

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Thanks very Much!!


-----Original Message-----
Hi

Use kg for the from unit
Use lbm for the to unit

That gives the result in lbs.

To get stones you divide the result by 14.

If you want stones and pounds then you can use something
like:

=INT(CONVERT(A1,"kg","lbm")/14)&" stones
"&MOD(CONVERT(A1,"kg","lbm")/14,1)*14&" pounds"

or:

=CONVERT(A1,"kg","lbm")/14
format: # ?/14

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia



.