How do I convert kilograms to ounces in excel?

P

Pearl

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

Dave F

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

1000 oz = 28.3495231 kg.

Dave
 
T

Toppers

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
 
P

Peo Sjoblom

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)
 
S

Sloth

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"
 
Top