Convert grams into kilograms

How to convert grams into kilograms?
How to convert kilograms into grams?

Assuming that you have typed your data in grams and your boss wants them in kilograms and that too in short time. To make things worse, your data is quite big to effect changes.
No problem, you can do this at a flash. Just follow the steps below:

1. Type 1000 in an empty cell
2. Right click and select copy (or press CTRL+C)
3. Now select the range of your data (assume that your data in grams consists of the range A1:A120").
4. Right click and select PASTE SPECIAL.
5. Select the DIVIDE option from the OPERATION group box.
6. Click OK and your job is done.

To convert kilograms into grams repeat the above steps and the select the MULTIPLY option instead of the DIVIDE option from the OPERATION group box. You can use the same tip to convert any unit into another. Just use the appropriate option.