I am using the convert function but can not find one for Kilograms??? Does
this exsist?

Why not just use the conversion ratio in a plain mathematical statement?

1000 oz = 28.3495231 kg.

Dave
--
Brevity is the soul of wit.


"Pearl" wrote:

I am using the convert function but can not find one for Kilograms??? Does
this exsist?

Why not convert your kilograms to grams or use

=Convert(1,"g","ozm")*1000 where 1= 1 kg

=Convert(2000,"g","ozm") = 2 kg

HTH

"Pearl" wrote:

I am using the convert function but can not find one for Kilograms??? Does
this exsist?

Looking more carefully at HELP for CoNVERT:

=CONVERT(1,"kg","ozm")

"Pearl" wrote:

I am using the convert function but can not find one for Kilograms??? Does
this exsist?

Note that the OP needs the Analysis ToolPak installed to use the convert
function

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"Toppers" wrote in message
...
Why not convert your kilograms to grams or use

=Convert(1,"g","ozm")*1000 where 1= 1 kg

=Convert(2000,"g","ozm") = 2 kg

HTH

"Pearl" wrote:

I am using the convert function but can not find one for Kilograms???
Does
this exsist?

FROM HELP UNDER CONVERT...

The following abbreviated unit prefixes can be prepended to any metric
from_unit or to_unit.

Prefix Multiplier Abbreviation
exa 1E+18 "E"
peta 1E+15 "P"
tera 1E+12 "T"
giga 1E+09 "G"
mega 1E+06 "M"
kilo 1E+03 "k" <---- LOOK HERE
hecto 1E+02 "h"
dekao 1E+01 "e"
deci 1E-01 "d"
centi 1E-02 "c"
milli 1E-03 "m"
micro 1E-06 "u"
nano 1E-09 "n"
pico 1E-12 "p"
femto 1E-15 "f"
atto 1E-18 "a"

"Pearl" wrote:

I am using the convert function but can not find one for Kilograms??? Does
this exsist?