Convert column from kilobyte to gigabyte and terabyte

[hackery]

I am looking for the easy way to convert an entire column filled with kilobytes into gigabytes and terrabytes? I am using excel 2007 and would like to update this excel workbook in the future by copying/pasting new kilobyte values into the columns and have them automatically converted to giga/terrabytes. Here is an example of columns containing the values. Thanks in advanced for your help

[shg]

If the data is in kB, then put =1024^2 in a cell. Copy it, select the cells you want to change to GB, and do Edit > Paste Special, Divide.

To convert to TB, use 1024^2

[hackery]

If the data is in kB, then put =1024^2 in a cell. Copy it, select the cells you want to change to GB, and do Edit > Paste Special, Divide.

To convert to TB, use 1024^2

Thanks for reply and it does work well! Is there a way to make it a 5 decimal result instead of a 10 decimal sum?

[shg]

There are buttons on the Formatting toolbar to change the number of decimal places.