Search code examples
excel-formula

EXCEL - Convert TON to KG incorrect

I have Excel 365 on MAC.

I want to convert "weight unit" in another "weight unit". =CONVERT(number; from_unit; to_unit)

Why is 1 ton = 907kg ? This should be 1000kg

Amount  Unit        Amount          Unit
1   ton =>  907,18474   kg
1   kg  =>  1000            g
1   g   =>  1000            mg

What is the correct way to convert?

Thanks, Aykut

Solution

  • In Britannica encyclopedia defined ton: ton, a unit of weight in the avoirdupois system equal to 2,000 pounds (907.18 kg) in the United States (the short ton) and 2,240 pounds (1,016.05 kg) in Britain (the long ton). The metric ton used in most other countries is 1,000 kg, equivalent to 2,204.6 pounds avoirdupois.

    Microsoft Excel just support "ton" and "uk_ton"