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?