Converting kg to tonnes in Excel

To convert kg to tonnes in Excel, follow these steps:

1. Open a new or existing Excel worksheet.
2. Enter the value in kg that you want to convert to tonnes in a cell. For example, let's say you want to convert 5000 kg to tonnes, you would enter "5000" in a cell.
3. In another cell, enter the formula "
   Formula:

   =A1/1000 

   " (without the quotes), where A1 is the cell containing the value in kg that you want to convert. This formula will divide the value in kg by 1000 to convert it to tonnes.
4. Press Enter to calculate the result. The cell containing the formula will now display the value in tonnes. In our example, the result would be "5" tonnes.

That's it! You have successfully converted kg to tonnes in Excel using a simple formula. You can now use this formula to convert any value in kg to tonnes in your Excel worksheet.

Divide by 1000.

[And next time, please ask your question in the body of the message, not in
the subject line.]
--
David Biddulph

"dave1234" wrote in message
...

And if you mean kg to tons, take a look at the
CONVERT function in the help file.

HTH
Martin


"dave1234" wrote in message
...